By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Access 2007 Report Conditional Formatting

P: 33
Please help: I have Conditional Formatting on a Report Field that fills the background Red if the criteria is met. This displays correctly in Report View, however, when I "OutputTo" this report to "Rich Text Format (*.rtf)", the colour is lost on the resultant RTF document when I open it up in Word 2007.

I would obviously like to retain the colours dictated by my Conditional Formatting criteria results when I output this report to RTF format.

Is this common and as it should be or am I missing something?
Mar 8 '09 #1
Share this Question
Share on Google+
4 Replies


maxamis4
Expert 100+
P: 295
I have always found that exporting my reports from Access to Word, Excel or Power Point never hold there format the same. I my self have taken the approach to create custom templates where the reports are generated in word, excel, etc. This way my reports don't require access to the database and are formatted automatically.

When it comes to colors especially I have yet to have an export that does it correctly.

Sorry hopefully someone esle might have a better answer
Mar 9 '09 #2

NeoPa
Expert Mod 15k+
P: 31,277
RTF is a very limited format.

I would consider using PDF for something where the layout and colours are important.
Apr 4 '09 #3

P: 33
Thanks guys, I have reverted to PDF as that was the only option.

Regards
Apr 5 '09 #4

NeoPa
Expert Mod 15k+
P: 31,277
Good for you Riaane. I suspect that will prove more workable (if producing larger files).
Apr 5 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.