I have been trying to format a letter as an access report and the main body of the leter is a block of text with some variables from a database. I need to be able to change the text formatting within the block of text without losing the flow of the letter (no new lines or spacing). For example:

textBody = "Dear " & strPerson & "! You dues should be in between " & strDueDateRange & " in order for your service to be uninterrupted."

But in the report, I need strPerson to show up in Bold and strDueDateRange to be underlined.

I have found some rich text activeX help on the web, but I can't seem to get it to work. But I would be glad to get this to work using any methods.

Thanks for any help out there.