conditional formatting

[Guest]

I have a field in a continous form that I use conditonal formatting.
Everything works fine, however, when I analyze the data to excel I lose the
formating. Any ideas on how I can bring the formatting across to excel when
analyzing/saving.

 

[Shaun Beane]

unfortunately, this is just one of the features that does not port to excel
when analyzing or exporting to excel.

you would have to take the time to program via VBA exporting of the data
and the condition formatting using the excel object model.

Shaun Beane, MCT, MCDST, MCDBA
dbageek.blogspot.com

 

[Douglas J Steele]

The only possible way would be to use Automation, and put the same
conditional formatting in Excel as you have in Access.

Other than that, all you're passing to Excel are the values of the fields:
formatting isn't transferred.

 

[Guest]

Thanks Shaun!

unfortunately, this is just one of the features that does not port to excel
when analyzing or exporting to excel.

you would have to take the time to program via VBA exporting of the data
and the condition formatting using the excel object model.

Shaun Beane, MCT, MCDST, MCDBA
dbageek.blogspot.com