Getting whole record to be shown in different text color in reports.

[Joe M]

On a form, I did

Fruit.OnExit
Fruit="Apple"
Fruit.forecolor= vbred
end if

This means that when the value "apple" is insert into the [fruit] field, the
text would turn red. But how do I do this on a report ??? This means that
any rows/records with the value "apple" in the [fruit] field, the text
colour for the row/record or even just the field would be display in red.
Records/rows with the apple value, would still be shown in black. How can
this be done, thanks alot.

 

[Terry]

Joe,

Have a look at "conditional formatting" (assuming your are
using Access 2000 or later). In design view select the
control you want to change colour and then in the format
drop down list ......


HTH

Terry

 

[Joe M]

Hi Terry,
What I want was any rows/records with the field "Fruit" having
the value 'Apple' should have the textcolor for just the specific row/record
turn red.
In the format drop down list I cannot see the option to do this procedure.
There's just forecolor, and this would turn all text to a different color.
Please list the steps of what to do thanks..

Joe,

Have a look at "conditional formatting" (assuming your are
using Access 2000 or later). In design view select the
control you want to change colour and then in the format
drop down list ......


HTH

Terry

-----Original Message-----
On a form, I did

Fruit.OnExit
Fruit="Apple"
Fruit.forecolor= vbred
end if

This means that when the value "apple" is insert into the [fruit] field, the
text would turn red. But how do I do this on a report ??? This means that
any rows/records with the value "apple" in the [fruit] field, the text
colour for the row/record or even just the field would be display in red.
Records/rows with the apple value, would still be shown in black. How can
this be done, thanks alot.



.

 

[tina]

as Terry said, Conditional Formatting is only available in A2000 or newer
software. if you have that, then

open the report in design view.
click on the control to select it.
on the menu bar, click Format, Conditional Formatting...
for Condition 1, set Field Value Is, equal to (in the next box), and type
"Apple" in the third box. then set your format with the buttons below the
third box.
click OK.

hth

Hi Terry,
What I want was any rows/records with the field "Fruit" having
the value 'Apple' should have the textcolor for just the specific row/record
turn red.
In the format drop down list I cannot see the option to do this procedure.
There's just forecolor, and this would turn all text to a different color.
Please list the steps of what to do thanks..

Joe,

Have a look at "conditional formatting" (assuming your are
using Access 2000 or later). In design view select the
control you want to change colour and then in the format
drop down list ......


HTH

Terry

-----Original Message-----
On a form, I did

Fruit.OnExit
Fruit="Apple"
Fruit.forecolor= vbred
end if

This means that when the value "apple" is insert into the [fruit] field, the
text would turn red. But how do I do this on a report ??? This means that
any rows/records with the value "apple" in the [fruit] field, the text
colour for the row/record or even just the field would be display in red.
Records/rows with the apple value, would still be shown in black. How can
this be done, thanks alot.



.

 

[Terry]

Joe,

How did you go? As Tina suggested it will only format the
text for the rows that meet your condition (=apple) and
revert all opther rows to the default formating for the
text box.
If you are still having problems please let us know what
version of Access you are running.

HTH

Terry

-----Original Message-----
Hi Terry,
What I want was any rows/records with the field "Fruit" having
the value 'Apple' should have the textcolor for just the specific row/record
turn red.
In the format drop down list I cannot see the option to do this procedure.
There's just forecolor, and this would turn all text to a different color.
Please list the steps of what to do thanks..

Joe,

Have a look at "conditional formatting" (assuming your are
using Access 2000 or later). In design view select the
control you want to change colour and then in the format
drop down list ......


HTH

Terry

-----Original Message-----
On a form, I did

Fruit.OnExit
Fruit="Apple"
Fruit.forecolor= vbred
end if

This means that when the value "apple" is insert into

the
[fruit] field, the

text would turn red. But how do I do this on a

report ???
This means that

any rows/records with the value "apple" in the [fruit] field, the text
colour for the row/record or even just the field

would
be display in red.

Records/rows with the apple value, would still be shown in black. How can
this be done, thanks alot.



.

.