conditional formatting on a form

[keri]

I would like to set up conditional formatting on a form.

One of the fields on the form is a date ([calldate]). If the calldate
field is over 365 days ago I would like all the other fields on the
form line to turn green but I am not sure if this is possible.

Thanks

[Scott McDaniel]

On Wed, 20 Jun 2007 04:05:49 -0700, keri <ke********@hotmail.comwrote:

>I would like to set up conditional formatting on a form.

One of the fields on the form is a date ([calldate]). If the calldate
field is over 365 days ago I would like all the other fields on the
form line to turn green but I am not sure if this is possible.

I'm assuming this is either Continuous or Datasheet view, as you mention a "line". You can use Conditional formatting to
do this, but you'd need to place it in every other control on the form to turn the backcolor green. You'd use the
"Expression Is" condition, then set the value to something like "DateDiff("d", calldate, Now)>365", and set the
backcolor to whatever you choose.

See online help for the DateDiff function

>
Thanks

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

[Neil]

One thing you can do as an alternative, which would be simpler to implement,
would be to have the background color of the record change if it's over 365
days. That might produce the same effect for you.

To do that, simply create a text box that's exactly the same size as the
detail section. Set its ControlSource to CallDate. Set its Enabled property
to False. And click on Move to Back, so that it's behind other controls.
Then simply set the Conditional Formatting for this textbox, and it will
change the background color of the section when the date is over 365 days.

Neil
"keri" <ke********@hotmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

>I would like to set up conditional formatting on a form.

One of the fields on the form is a date ([calldate]). If the calldate
field is over 365 days ago I would like all the other fields on the
form line to turn green but I am not sure if this is possible.

Thanks