Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a reminder form which brings up on each day reminders overdue on that
day and also previous reminders that havent been completed for days before
today. What I would like to do is to make those 'previous' reminders that
are overdue before today to turn red when the reminder form pops up. I am
unsure how the conditional formatting works and what I would enter for the
information to achieve this.

Many thanks in advance.
 
Have you experimented with conditional controls? In form design mode,
select Format-Conditional formatting for any text control. You set the
default look and can set 3 different conditions that will force a different
look of that particular control. This tends to work best for one
independent control. i.e, your txtReminderDate could change color based on
how many days it is in the past. For more than one dependent controls, it's
best to use code statements, i.e.
If txtReminderDate<Date()-30 then
Me!txtReminderMessage.ForeColor=255 'red
Else
Me!txtReminderMessage.ForeColor=0 'black
End If

-Ed
 
Back
Top