Using a variable to compile to a rich text report
Posted on 2011-09-06
I want to be able to compile a rich text report using VBA. I am constructing my data to include verbiage and variables and then I use cases to loop through an entire report to fill a string variable with all the text, variable results, and things like vbCr's to make a report. I do not want to construct the report in Word, but after edits I want to output it to Word.
My problem: If I convert the field in the table with the verbiage "blurbs" to Rich text, and I use the immediate window to view the compiled information, I get HTML tags. I want to be able to output the compiled verbiage to either a text box on a form or a report -- I am ambivalent as to which one.
How to I get my variable to "dump" the compiled formatted verbiage and variables to a form or report? Is there a command to do this?