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

[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!

 

[Marshall Barton]

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.

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