A97: Controlling font in export to Word

L

Lee Schipper

For Access97.

I have a report that users export to Word, then make minor edits to.

The data in my report is formatted as 9-point Arial. When Access exports to
an RTF file, the data is formatted as 9-point Arial just fine, however where
Access inserts Tab characters between my data fields, the tabs are
effectively being formatted as 12-point MS Sans Serif.

Is there any way to force or trick Access into writing those tabs in a
9-point Arial font?

Nitpicky? Yes. But when the end users edit these RTF files they type stuff
in after the tab characters and their typed text comes out in 12-point MS
Sans Serif, and then they grumble.

I have thought that I might export to Word, then re-open the file using
automation and translate all 12-point MS Sans Serif to 9-point Arial, but
given the way the users run the reports that would be difficult for me to
do.

Thanks for any ideas!
Lee
 
Top