Retain Formatting

[Guest]

What would the code look like for exporting a report from access to Word so
that it will retain the formatting? I know that the data is exported as the
raw data, and things like specific font bolding etc are left off in the
export. Is there even a way to make it retian this formatting? Thanks in
advance!!!


DoCmd.OutputTo acReport, "BARRHEAD REPORT", "RichTextFormat(*.rtf)",
"C:\MYFOLDER\MDA(Dealer_777777).doc", False, "", 0

 

[Douglas J. Steele]

You're creating an RTF document. Things like bold font should be transferred
without any problem. Graphics and lines should be the only things that
aren't transferred.

Is this different than what you're experiencing? What version of Access are
you using?

 

[Guest]

I'm using Access 2003. I figured the same thing that an .rtf would retain
all the formatting, however it's not. Within the report, there is some
conditional formatting

for example:

[RI]="N" Bold

So if the RI column is an "N" then the entire row will be bolded. Now
having that conditional formatting on, is that why it wouldn't transfer over?


Any suggestions? Thanks!!!

 

[Douglas J. Steele]

Yes, it may very well be related to conditional formatting.

Take a look whether what Stephen Lebans has at
http://www.lebans.com/ReportUtilities.htm works any better.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm using Access 2003. I figured the same thing that an .rtf would retain
all the formatting, however it's not. Within the report, there is some
conditional formatting

for example:

[RI]="N" Bold

So if the RI column is an "N" then the entire row will be bolded. Now
having that conditional formatting on, is that why it wouldn't transfer
over?


Any suggestions? Thanks!!!

You're creating an RTF document. Things like bold font should be
transferred
without any problem. Graphics and lines should be the only things that
aren't transferred.

Is this different than what you're experiencing? What version of Access
are
you using?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


in
message news:[email protected]...