Conditional Formating

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

Guest

I asked this before but none of the answers worked. Let me rephrase the
question.

On my form I have a field for birthdates that are filled in automatically
from a
query. What I want is the background to change to a predetermined color if
the
day portion of their birthday matches today's date. In the forms birthday
field I have it setup so that it only shows the date and month dd/mmmm.
First I highlighted the date field then opened conditional formating. In
there I selected Field Equals Date()
There needs to be something added to that so it only looks at the day of the
current month.
As of now Date() would work if someone was born today and if I roll my
computers clock backwards to someone's birth date it does work. Needs to add
something to the Date() statement ie Date(),dd - which doesn't work.

Thanks
 
Here is what you need for your conditional formatting

format(date(),"dd/mmmm") = txtBirthday

Where txtBirthday is the value returned by your query
Be sure you select "Expression Is" in the condition wizard
 
Back
Top