Field Background Color

G

George

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
?
 
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
 
G

George

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
 
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
 
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
?
Click to expand...

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
Click to expand...

Regarding:> and entered =Date() <
Do NOT use the = sign!
Just
Date()

Field Value Is
Equal To
Date()
 
Top