View Single Post
  #2 (permalink)  
Old April 25th, 2008, 11:32 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You are using the wrong event. Use the Detail section's On Format event for this. I use the following code to change the Font color. I am note sure about the text box color.

In the On Format event:

If ((Month(Now) = 4) And (Me.Apr = True)) Then
    Me.Machine.ForeColor = vbRed
    Me.Machine.FontBold = True
Else
    Me.Machine.ForeColor = vbBlack
    Me.Machine.FontBold = False
End If

Did that help?


mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote