How do I make fields change colors to alert something?

[Guest]

I have been asked to create a database based on a control sheet which tracks
when visits are due, past due or need follow-up. Right now they maintain it
on an Excel spreadsheet and use color coding to let them know when visits are
due and such. Is there anyway to do this with the database as well? Please
be as detailed as possible when replying. Thanks!

 

[RoyVidar]

I have been asked to create a database based on a control sheet which
tracks when visits are due, past due or need follow-up. Right now
they maintain it on an Excel spreadsheet and use color coding to let
them know when visits are due and such. Is there anyway to do this
with the database as well? Please be as detailed as possible when
replying. Thanks!

In a continuous form, or datasheet, you can use conditional
formatting (format menu), which is quite close to how it is done in
Excel. This requires 2000 version or later. You are limited to three
conditions, which I think is the same as Excel.

For single forms, you can also set backcolor etc on controls
programatically (perhaps using the on current event) in stead of
conditional formatting.

 

[Jeff L]

Have you checked out conditional formatting?

 

[Guest]

I have, but unfortunately the training my company sent me to did not cover
conditional formatting. If I have a field that says a monitoring visit was
done today, how would I get it to turn blue in 30 days? Can that be done?
And then if it goes past 30 days, can it turn red?

 

[Jeff L]

You can have up to 3 conditions. Select the field you want to have
conditional formatting on. Click Format, Conditional Formatting in the
menu. You will see a window open. The conditions you would use are:
DateDiff("d", [YourDateField], Date()) = 30
DateDiff("d", [YourDateField], Date()) > 30

For each condition, select what you want to do...ie change the
background to blue or red. There is an icon that looks like a bucket
that you use to chage the background color.

Hope that helps!