G
Guest
In my form I have a birthdate field - is it possible to have that field
change to a predetermined color or flash when that date matches today's date
?
change to a predetermined color or flash when that date matches today's date
?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Yes, use the conditional formatting. It is in the format menu. Say that if
the field value is =Date() then set your color/options. I'm not sure
if background color is one of the options, but you could change the font
color, bold, underline, etc.
Hope that helps,
Rick B
the field value is =Date() then set your color/options. I'm not sure
if background color is one of the options, but you could change the font
color, bold, underline, etc.
Hope that helps,
Rick B
G
Guest
Rick - I found the conditional formating but I couldn't get it to work.
I highlighted the date field
Went to conditional formating and selected "Field is Equal to" and entered
=Date()
Then selected a background color to change to when the date equals today's
date.
The only thing I can think of that may cause a problem is that the forms's
Date Field I have the property set to display as dd/mmmm - do I need to
tweek the formating to recognize that date format ?
George
I highlighted the date field
Went to conditional formating and selected "Field is Equal to" and entered
=Date()
Then selected a background color to change to when the date equals today's
date.
The only thing I can think of that may cause a problem is that the forms's
Date Field I have the property set to display as dd/mmmm - do I need to
tweek the formating to recognize that date format ?
George
R
Rick B
You can try it. I would guess that conditional formatting compares what is
in the control (01/January), not what is in the actual field.
You might try something like...
=Format(Date(),"dd/mmmm")
Rick B
in the control (01/January), not what is in the actual field.
You might try something like...
=Format(Date(),"dd/mmmm")
Rick B
G
Guest
Tried this but got syntax error when using this formula.
F
fredg
In my form I have a birthdate field - is it possible to have that field
change to a predetermined color or flash when that date matches today's date
?
If your version of access has conditional formatting (Access 2000 or
newer), select the control. Click on Format + Conditional formatting.
Set the Condition1 drop downs to:
Field Value Is Equal to Date()
select the color you want. Save the changes.
F
fredg
Rick - I found the conditional formating but I couldn't get it to work.
I highlighted the date field
Went to conditional formating and selected "Field is Equal to" and entered
=Date()
Then selected a background color to change to when the date equals today's
date.
The only thing I can think of that may cause a problem is that the forms's
Date Field I have the property set to display as dd/mmmm - do I need to
tweek the formating to recognize that date format ?
George
Regarding:> and entered =Date() <
Do NOT use the = sign!
Just
Date()
Field Value Is
Equal To
Date()