title: MS Access Convert like function to Memo Data Type
body: <p>I need to use rich text formatting for a field in a report in MS Access in order to use character spacing. In the report, attempting to change the Text Format in the field's properties from Plain Text to Rich Text Produces the error: "The setting you entered isn't valid for this property." I presume that is because the field is not a memo data type, (apparently the only data type which supports RTF). It is in the format "<em>XXXX_XXXX</em>" where * and _ are literal characters and the X's represent numbers 0 through 9.</p>
  
  <p>For context: The workflow of this DB is that it has a single form that when specifying an Id, queries a linked table, generates a report based on the query result, and outputs it to PDF. </p>
  
  <p>The field's control source is a field from the query result.</p>
  
  <p>Everything works fine but I need to be able to set this field to RTF. The font is a TrueType font if that makes any difference. Essentially I want to have a fixed height on the field and stretch it horizontally across the width. i.e. in CSS it would be defined roughly as "max-height: 30px; width: 100%;"</p>
  
  <p>Things that I have tried: </p>
  
  <p>In the Query Design View, setting the field's Text Format to Rich Text. I still receive an error when setting the field's Text Format in the Report Design View.</p>
  
  <p>Other idea is to explicitly convert field to the Memo data type (anything over 255 implicitly gets converted to this type), but I am not sure of how to do that in SQl [MS SQL Server we would use something like CONVERT([fieldname], text)]</p>
  
  <p>Would creating a custom format help? I'd imagine not because it would still be plaintext.</p>
  
  <p>Thanks in advance for any help and comments.</p>