Red or Green Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
KAnoe said:
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??
Click to expand...


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

Marshall Barton said:
KAnoe said:
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??
Click to expand...


You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.
Click to expand...
 
PMFJI,
Did you consider searching Help? How far did you get?

--
Duane Hookom
MS Access MVP


KAnoe said:
How?

Marshall Barton said:
KAnoe said:
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??
Click to expand...


You can use Conditional Formatting (Format menu) to specify
your conditions and property settings.
Click to expand...
Click to expand...
 
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.

Duane Hookom said:
PMFJI,
Did you consider searching Help? How far did you get?

--
Duane Hookom
MS Access MVP


KAnoe said:
How?

Marshall Barton said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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
--

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

Duane Hookom said:
PMFJI,
Did you consider searching Help? How far did you get?

--
Duane Hookom
MS Access MVP


KAnoe said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top