Highlight Datasheet Row

[Ava via AccessMonster.com]

I have a subform in datasheet view. The user needs to be able to highlight a
datasheet row in either green, yellow or red.

How can I code so that when the user is on a row, he can highlight that row
any of the colors above?

Thanks,
Ava

 

[fredg]

I have a subform in datasheet view. The user needs to be able to highlight a
datasheet row in either green, yellow or red.

How can I code so that when the user is on a row, he can highlight that row
any of the colors above?

Thanks,
Ava

See what Stephan Lebans has.

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