Highlight field in continuous form - based on value in field

I have some dates which show in a continuous form, multiple rows at a
time. I would like to color the background yellow, or the text yellow
or some color other than black that would stand out, based on the date
value. Suggestions?

I have worked out highlighting red text in fields with missing text or
dates.

On forms with only one record at a time, highlighting background is
straightforward.

Bob

On Tue, 14 Dec 2004 19:45:24 -0600, Bob Alston wrote:
[color=blue]
> I have some dates which show in a continuous form, multiple rows at a
> time. I would like to color the background yellow, or the text yellow
> or some color other than black that would stand out, based on the date
> value. Suggestions?
>
> I have worked out highlighting red text in fields with missing text or
> dates.
>
> On forms with only one record at a time, highlighting background is
> straightforward.
>
> Bob[/color]

If you are using Access 2000 or newer, you can set the control's
Conditonal Formatting to change the control's BackColor or ForeColor
based upon it's Value.
In Design View, select the Control.
Click
Format + Conditional Formatting
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Slick. Hadn't see that before. Guess I still think Access97.
Thanks.

Bob

and if you're using access97, can it be done ?

lesperancer@natpro.com wrote:[color=blue]
> and if you're using access97, can it be done ?[/color]

Not really. I have emulated a continuous form, and in that case it can
be done. See the MultiList project on my site if you feel the urge.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea