By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Highlight field in continuous form - based on value in field

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Tue, 14 Dec 2004 19:45:24 -0600, Bob Alston wrote:
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


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.
Nov 13 '05 #2

P: n/a
Bob
Slick. Hadn't see that before. Guess I still think Access97.
Thanks.

Bob

Nov 13 '05 #3

P: n/a
and if you're using access97, can it be done ?

Nov 13 '05 #4

P: n/a
le*********@natpro.com wrote:
and if you're using access97, can it be done ?


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
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.