Maintain formatting when exporting to Word or Excel

B

Brandon

I have a report that formats the back color of the value
based on the value in the cell. Code is
Select Case Me!Status.Value
Case Is = 1
Me!Status.BackColor = 8454016
'green
Me.Status.ForeColor = 0
'black

and several other colors. When I export the report to
Word or Excel, the backcolors do not go with the report.
How can I maintain the back color formatting when exported?
Also I have some DSum Total text boxes at the bottom of
the report. They do not carry over when I export to
Excel, but they do carry over when I export to Word. Is
there a way to carry the total boxes over in Excel?
Thanks for your help!
Brandon
 
Top