Change font on past due date selected from ocxCalendar to appear r

  • Thread starter Thread starter Jacquiemal
  • Start date Start date
J

Jacquiemal

I have a bunch of date due and date sent fiels on a form that rely on an
ocxCalendar to fill them in. I would like the date of the "sent" field to
appear red and bold and have a comment box appear for an explanation if the
"sent" date is past the "due" date. How would I do this? Any help
appreciated, thanks!
 
Jacquiemal said:
I have a bunch of date due and date sent fiels on a form that rely on an
ocxCalendar to fill them in. I would like the date of the "sent" field to
appear red and bold and have a comment box appear for an explanation if the
"sent" date is past the "due" date.
Click to expand...


You can use Conditional Formatting (Format menu) to get the
color and bold. The message can be done in the form's
Current event:

If Me.txtAbcDue < Me.txtAbcSent Then
MsgBox "Sent is after due"
End If
 
Back
Top