Highlighting Text Boxes

  • Thread starter Thread starter Antney
  • Start date Start date
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.
 
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?
Click to expand...


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"
 
Back
Top