Red or Green Text

[Guest]

I'm doing a Report and I would like to NOT use Excel!! I have a Text_Bx that
has a Percent in it [% Msn Achv] and a 2nd Text_Bx that I would like to
compare is to [Text101].

If the [% Msn Achv] is less than [Text101] the text in [Text101] would be
RED and Bold.

It the [% Msn Achv] is the same or grater that [Text101] the text in
[Text101]would be Green.

I can have the use do it in Excel but all that data is in Access. Can I do
this??

 

[Marshall Barton]

I'm doing a Report and I would like to NOT use Excel!! I have a Text_Bx that
has a Percent in it [% Msn Achv] and a 2nd Text_Bx that I would like to
compare is to [Text101].

If the [% Msn Achv] is less than [Text101] the text in [Text101] would be
RED and Bold.

It the [% Msn Achv] is the same or grater that [Text101] the text in
[Text101]would be Green.

I can have the use do it in Excel but all that data is in Access. Can I do
this??

You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.

 

[Guest]

How?

I'm doing a Report and I would like to NOT use Excel!! I have a Text_Bx that
has a Percent in it [% Msn Achv] and a 2nd Text_Bx that I would like to
compare is to [Text101].

If the [% Msn Achv] is less than [Text101] the text in [Text101] would be
RED and Bold.

It the [% Msn Achv] is the same or grater that [Text101] the text in
[Text101]would be Green.

I can have the use do it in Excel but all that data is in Access. Can I do
this??

You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.

 

[Duane Hookom]

PMFJI,
Did you consider searching Help? How far did you get?

--
Duane Hookom
MS Access MVP

How?

I'm doing a Report and I would like to NOT use Excel!! I have a Text_Bx that
has a Percent in it [% Msn Achv] and a 2nd Text_Bx that I would like to
compare is to [Text101].

If the [% Msn Achv] is less than [Text101] the text in [Text101] would be
RED and Bold.

It the [% Msn Achv] is the same or grater that [Text101] the text in
[Text101]would be Green.

I can have the use do it in Excel but all that data is in Access. Can I do
this??

You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.

 

[Guest]

I looked in my Access Que Book and the Help and the only thing that I could
find was setting the text color. I could not find anything about changing the
color depending on the value of the Text box.

PMFJI,
Did you consider searching Help? How far did you get?

--
Duane Hookom
MS Access MVP

How?

KAnoe wrote:

I'm doing a Report and I would like to NOT use Excel!! I have a Text_Bx that
has a Percent in it [% Msn Achv] and a 2nd Text_Bx that I would like to
compare is to [Text101].

If the [% Msn Achv] is less than [Text101] the text in [Text101] would be
RED and Bold.

It the [% Msn Achv] is the same or grater that [Text101] the text in
[Text101]would be Green.

I can have the use do it in Excel but all that data is in Access. Can I do
this??


You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.

 

[Duane Hookom]

What version of Access are you using? If Access 2000 or higher, open Help
and search on "Conditional Formatting". You can use an expression
[txtExpression1]<[txtExpression2]


--
Duane Hookom
MS Access MVP
--

I looked in my Access Que Book and the Help and the only thing that I could
find was setting the text color. I could not find anything about changing
the
color depending on the value of the Text box.

PMFJI,
Did you consider searching Help? How far did you get?

--
Duane Hookom
MS Access MVP

How?

:

KAnoe wrote:

I'm doing a Report and I would like to NOT use Excel!! I have a
Text_Bx that
has a Percent in it [% Msn Achv] and a 2nd Text_Bx that I would like
to
compare is to [Text101].

If the [% Msn Achv] is less than [Text101] the text in [Text101]
would be
RED and Bold.

It the [% Msn Achv] is the same or grater that [Text101] the text
in
[Text101]would be Green.

I can have the use do it in Excel but all that data is in Access.
Can I do
this??


You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.