conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
Thanks Shaun!

Shaun Beane said:
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
Click to expand...
 
Back
Top