Change Font Size When Exported to Word

[darkmindx]

Hi,

I want to output a report as an rtf file. I do this with:

DoCmd.OutputTo acReport, "Testing", acFormatRTF, "C:\Program Files\Test.rtf", True

I have my report in 8 point font. When it exports it to an rtf file, how can I change the font to 12 so when the rtf file automatically opens, all of the text in it is 12 point font. I tired:

DoCmd.OutputTo acReport, "Testing", acFormatRTF, "C:\Program Files\Test.rtf", True
[b]Selection.Font.Size = "12"[/b]

...but it doesn't seem to work.


Thanks


P.S. - I know that I can set the font to 12 in the report itself, but I am having truncating issues and I want to see if this fixes it.

 

[darkmindx]

Does anybody know how to do this? I would really appreciate it.


Thanks

 

[sfm6s524]

I'm confused as to why your own solution won't work. What is the truncating issue you are seeing?

Ken

 

[BobStubbs]

Take a look at thread thread181-1031803 with regard to your truncating issues. This may be the same problem ...

Bob Stubbs