Variable Font or Background Color

  • Thread starter Thread starter Lloyd
  • Start date Start date
L

Lloyd

Can someone share with me code (Access97) that will, when
a form is opened, display the font color or background
color of a date field in a form in a different color when
the date has past today's date.

Thanks, Lloyd
 
Can someone share with me code (Access97) that will, when
a form is opened, display the font color or background
color of a date field in a form in a different color when
the date has past today's date.

Thanks, Lloyd
Click to expand...

In Access 97, using Single Form View only, you can code the form's
Current event:
If Me![DateField] < Date then
Me![DateField].ForeColor = vbYellow
Me![DateField].BackColor = vbRed
Else
Me![DateField].ForeColor = vbBlack
Me![DateField].BackColor = vbWhite
End If
 
Back
Top