Colour Format Problem Exporting Report to Word

[Rovers]

Conditional Formatting isn't an option becuase I have to support MS Access97 with this.

I currently use code in report groups to format specific results. Specifically preformance reports that are grouped by

Green 90-100%
Amber 75-89%
Red 0-74%

This works fine while printing and previwing in Access but when exporting to Word the colours are randomly different (albeit only red or green ANDNOT amber.)

I've tried using two colour formatting values for all colours:
i.e. the RGB (,,) and the number that Access gives if you pick from a pallette.

...but neither works

Can anyone please give a solution to keep the colour formatting?

 

[freakazeud]

Hi,
print to pdf or snapshot! This way all formatting will stay the same as it is on the report!
You can probably browse the forums for solutions on how to achieve both methods. To export as snapshot you need the snapshot viewer to be able to view the files! To export as pdf you need a pdf writer.
HTH
Good luck

 

[Rovers]

Thanks, but Iv'e already tried these options and clients want to manipulate reports once exported to word.

I know they could buy Acrobat Writer for this but I really want a solution so they can continue to use word.

I have other reports that export with colour perfectly, but there is no code behind those formats.

It only seems to be a problem when formatting with vba.

Thanks for responding, have you any other suggestions?