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

Datasheet view

P: n/a
Hi,
I am able to display the contents of a table to a form in datasheet
mode. I would like to change the background of the rows displayed to red or
blue depending on what the value of one column is. For example,

First Last Color
John Doe 'r'
Jack Roland 'b'
Peter Feller 'r'
....

If the Color field is 'r', then the row should be in red and if it is blue,
the row color should be blue. Is there a way to get this done in MS Access?

- Ren

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 06 Sep 2004 21:29:07 GMT, renniw one wrote:
Hi,
I am able to display the contents of a table to a form in datasheet
mode. I would like to change the background of the rows displayed to red or
blue depending on what the value of one column is. For example,

First Last Color
John Doe 'r'
Jack Roland 'b'
Peter Feller 'r'
...

If the Color field is 'r', then the row should be in red and if it is blue,
the row color should be blue. Is there a way to get this done in MS Access?

- Ren

Access 2002 or newer?
See
http://www.lebans.com
specifically:
http://www.lebans.com/conditionalformatting.htm
You can down load a sample database that includes various uses for
shaded lines, including continuous form alternating lines and
highlighting the selected line.

And also look at:
http://www.lebans.com/alternatecolordetailsection.htm
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.