Turn whole row/record red.

[Joe M]

Hi I would like to create a [Colour] field in table that would turn the
row/record into the colour based upon the value of the [Colour] field.
Meaning if the word "red" is type into the [Colour] field, the whole
row/record textcolour would turn red. And if value "blue" is type into the
[Colour] field, the whole row/record would turn blue. How do I do this??
Thanks.

 

[fredg]

Hi I would like to create a [Colour] field in table that would turn the
row/record into the colour based upon the value of the [Colour] field.
Meaning if the word "red" is type into the [Colour] field, the whole
row/record textcolour would turn red. And if value "blue" is type into the
[Colour] field, the whole row/record would turn blue. How do I do this??
Thanks.

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

 

[Joe M]

Hi Fred,
All I want is the text in the whole row/record to turn colour
blue, not highlighting the whole row.. Is there a more simpler way such as

If Me.Colour = "Blue" Then
Me.txtcolor = Blue
Field1.txtcolor=Blue
Field2.txtcolor=Blue
end if

Thanks

Hi I would like to create a [Colour] field in table that would turn the
row/record into the colour based upon the value of the [Colour] field.
Meaning if the word "red" is type into the [Colour] field, the whole
row/record textcolour would turn red. And if value "blue" is type into the
[Colour] field, the whole row/record would turn blue. How do I do this??
Thanks.

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