Send subform datasheet with Formating to Excel

  • Thread starter Thread starter Cagney
  • Start date Start date
C

Cagney

I have a subform in datasheet view with conditional formatting and
Check boxes. I want to send this subform DS exactly as it is formated
to Excel. But my check boxes turn into fields with True or False in
them, and my formatting is lost. How can i get this Subform Datasheet
sent to Excel as is, formating and all?
Thanks
Cagney
 
I have a subform in datasheet view with conditional formatting and
Check boxes. I want to send this subform DS exactly as it is formated
to Excel. But my check boxes turn into fields with True or False in
them, and my formatting is lost. How can i get this Subform Datasheet
sent to Excel as is, formating and all?
Thanks
Cagney
Click to expand...

Sorry for the omition, I am using Access 2003.
 
Cagney said:
I have a subform in datasheet view with conditional formatting and
Check boxes. I want to send this subform DS exactly as it is formated
to Excel. But my check boxes turn into fields with True or False in
them, and my formatting is lost. How can i get this Subform Datasheet
sent to Excel as is, formating and all?
Thanks
Cagney
Click to expand...

Try exporting to HTML, then open that in Excel. The formatting probably
won't be perfect, but usually with a few adjustments you should get
reasonable results.
 
Back
Top