View Single Post
  #2  
Old May 12th, 2005, 02:45 PM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default

Yes, in the Format event of the section of the report that the field is
reported in, you could set the formatting of the control for that field. A
Select Case statement may be the easiest.

Example:
Select Case Me.txtMyTextbox
Case "AB"
Me.txtMyTextbox.ForeColor = 8454143
Case 'etc
Case Else
Me.txtMyTextbox.ForeColor = 0
End Select

--
Wayne Morgan
MS Access MVP


"Tim" wrote in message
...
ACCESS 2000

There is a field in my database that requires highlighting; however, I
have
a total of 15 cases that requires, obviously I can't set that up with the
default C.F.

Is there a way to set up a VBA code that would allow me to set up the 15
conditions?