Reformat Memo Field

[shm135]

Hi,

I have a report that contains a memo field "Notes" that in the backend
tables are formatted as Rich Text fields. I want my Notes field in my
report to have a universal font name and font size. However, I would
like any bold, italic or underlined settings to still appear in the
notes field. I have tried setting the report's on load event to:

Me.Notes.FontSize = 10
Me.Notes.FontName = "Calibri"

That did not work. Neither did putting this code in the On Current or
On Format events. Any suggestions as to how I can make the notes field
in my report have the same font name, size (while still enabling bold,
italics, underline)? I can't change the entire field to be formatted
as plain text because it will then display the HTML coding.

Thanks

 

[Allen Browne]

If the field contains HTML that specifies a specify font name and size (e.g.
the <font> tag), that will override whatever setting you specify in the
control's properties.

If that's not the case, try setting the properties in the report's Open
event. Also try Print Preview rather than Report view.