Save as HTML formatting lost

P

pow67

Using Access 97 I have created a report which prints some names in
"BoldColor" and others in "DefaultColor" which are defined in the
following module:

Public Const BoldColor = vbBlue
Public Const DefaultColor = vbBlue

The code for the sub in my report is:

If (Me![BOLD] Or Me![Plus]) = True Then

Me![Name].ForeColor = BoldColor
Else

Me![Name].ForeColor = DefaultColor

End If

Everything looks fine on the Access screen however when I "save as HTML"
or publish to Word [Name] ignores "BoldColor" and prints all [Name] in
the "DefaultColor" .

Thanks in advance.

CW
 
P

pow67

Please ignore my earlier post.

Using Access 97 I have created a report which prints some names in
"BoldColor" and others in "DefaultColor" which are defined in the
following module:

Public Const BoldColor = vbRed
Public Const DefaultColor = vbBlue

The code for the sub in my report is:

If (Me![BOLD] Or Me![Plus]) = True Then

Me![Name].ForeColor = BoldColor
Else

Me![Name].ForeColor = DefaultColor

End If

Everything looks fine on the Access screen however when I "save as HTML"
or publish to Word [Name] ignores "BoldColor" and prints all [Name] in
the "DefaultColor" .

Thanks in advance.

CW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top