Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Font Size When Exported to Word

Status
Not open for further replies.

darkmindx

Technical User
Mar 25, 2005
16
US
Hi,

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

Code:
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:

Code:
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.
 
Does anybody know how to do this? I would really appreciate it.


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

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

Bob Stubbs
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top