| re: Highlight field in continuous form - based on value in field
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.
| 
