Conditional Formating

[Guest]

I have a database of personnel info. One form has a field that displays
birthdates for everyone who is born this month in the following format dd /
mmmmm, This data comes from a Query. What I am trying to do is when their
Birthdate ( just the day ) matches today date ( just the day ) have the
birthdates field background color change or flash to attract attention. I
have tried but can't get it to work. Any ideas what I can use as a expression
in the Conditional Format or other ideas.

 

[Wayne Morgan]

It displays in the format dd/mmmm, but is it stored in that format or do you
have an actual date in the field? If there is a date in the field try:

Format([FieldName], "dd") = Format(Date(), "dd")

If it is stored as you have it formatted then try "Field Value Is" instead
of "Expression Is" and use:

Format(Date(), "dd/mmmm")

 

[Guest]

Thank You - The first expression worked - many reponses but this one works.

Thanks.....

It displays in the format dd/mmmm, but is it stored in that format or do you
have an actual date in the field? If there is a date in the field try:

Format([FieldName], "dd") = Format(Date(), "dd")

If it is stored as you have it formatted then try "Field Value Is" instead
of "Expression Is" and use:

Format(Date(), "dd/mmmm")

--
Wayne Morgan
MS Access MVP

I have a database of personnel info. One form has a field that displays
birthdates for everyone who is born this month in the following format dd
/
mmmmm, This data comes from a Query. What I am trying to do is when their
Birthdate ( just the day ) matches today date ( just the day ) have the
birthdates field background color change or flash to attract attention. I
have tried but can't get it to work. Any ideas what I can use as a
expression
in the Conditional Format or other ideas.