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

  • Thread starter Thread starter Joe M
  • Start date Start date
J

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


Terry said:
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.



.
Click to expand...
Click to expand...
 
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


Joe M said:
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..


Terry said:
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.



.
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...
the
[fruit] field, the
text would turn red. But how do I do this on a
Click to expand...
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
Click to expand...
would
be display in red.
Records/rows with the apple value, would still be shown in black. How can
this be done, thanks alot.



.
Click to expand...
Click to expand...


.
Click to expand...
 
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.


Terry said:
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.



.
Click to expand...


.
Click to expand...
Click to expand...
 
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
Click to expand...
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
Click to expand...
to a
different color.
Please list the steps of what to do thanks..


Joe,

Have a look at "conditional formatting" (assuming
Click to expand...
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
Click to expand...
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.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
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.


Terry said:
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.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top