Highlighting Text Boxes

A

Antney

How do I highlight every other row (text boxes) in a report that is using
only 1 text box in the design mode and also, how do I highlight certain text
boxes, in the same report, based on certain criteria that appears in the text
box?

Thank you.
 
M

Marshall Barton

Antney said:
How do I highlight every other row (text boxes) in a report that is using
only 1 text box in the design mode and also, how do I highlight certain text
boxes, in the same report, based on certain criteria that appears in the text
box?


You can highlight alternating details in a report by using a
little code in the detail section's Format or Print event:

If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = vbGreen
Else
Me.Section(0).BackColor = vbWhite
End If

Highliting individual text boxes is usually done by using
Conditional Formatting on the View menu. If you can get
that to do what you want. post back with more information
about the "certain criteria that appears in the text box"
 

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

Similar Threads


Top