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.



.

.

 

[Joe M]

Thanks Terry,
Conditional formatting was precisely what I need, it's
now working. I would like to go further by turning the text color of the
whole row/record red. Not just the fruit field red. Is it possible to do
it with Conditional Formatting or do I need something else????? Thanks.

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.



.

.

 

[Terry]

Joe,

Glad to hear you got it going. You can apply the
same "conditional formating" to all controls in the
section and they'll all turn red (or whatever you've
specified).

HTH,

Terry

-----Original Message-----
Thanks Terry,
Conditional formatting was precisely what I need, it's
now working. I would like to go further by turning the text color of the
whole row/record red. Not just the fruit field red. Is it possible to do
it with Conditional Formatting or do I need something else????? Thanks.

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.



.



.

.

 

[Joe M]

Hi Terry,
What I mean is the whole row/record would turn red if that row
has the value "apple" in the field [Fruit]. The whole row text color will
be dependant on the field [FRUIT] alone.
Conditional Formatting seems to allow for one field only. It does not seem
to allow multiple fields dependant on the primary field.

Joe,

Glad to hear you got it going. You can apply the
same "conditional formating" to all controls in the
section and they'll all turn red (or whatever you've
specified).

HTH,

Terry

-----Original Message-----
Thanks Terry,
Conditional formatting was precisely what I need, it's
now working. I would like to go further by turning the text color of the
whole row/record red. Not just the fruit field red. Is it possible to do
it with Conditional Formatting or do I need something else????? Thanks.

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..


message
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.



.



.

.