Conditional Formating

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I'm not sure if this would be achieved in Queries or Forms. What I want to
do is highlight in red all the fields in a row when the value in the Code
field is 2 Or 4.

Can anyone help?

Bruce
 
You could use conditional formatting in the form to do that. You would use
the "ExpressionIs" option and put something like the following in the
expression box:

Code: 
=2 or [Code]=4


Rick B
 
Thanks Rick,it sounds promising can you expand on it. Where is the
Expression Box
Rick B said:
You could use conditional formatting in the form to do that. You would use
the "ExpressionIs" option and put something like the following in the
expression box:

Code: 
=2 or [Code]=4


Rick B

[QUOTE="Bruce"]
I'm not sure if this would be achieved in Queries or Forms. What I want to
do is highlight in red all the fields in a row when the value in the Code
field is 2 Or 4.

Can anyone help?

Bruce
[/QUOTE]
[/QUOTE]
Click to expand...
 
In conditional formatting, you will click on the first drop-down and select
"Expression Is". The next field is the box in which you would enter your
expression.

Rick B

Bruce said:
Thanks Rick,it sounds promising can you expand on it. Where is the
Expression Box
Rick B said:
You could use conditional formatting in the form to do that. You would use
the "ExpressionIs" option and put something like the following in the
expression box:

Code: 
=2 or [Code]=4


Rick B

[QUOTE="Bruce"]
I'm not sure if this would be achieved in Queries or Forms. What I[/QUOTE][/QUOTE] want[QUOTE]
to
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
 
Rick where do I find conditional formating tool in Access 97?
Rick B said:
In conditional formatting, you will click on the first drop-down and select
"Expression Is". The next field is the box in which you would enter your
expression.

Rick B

Bruce said:
Thanks Rick,it sounds promising can you expand on it. Where is the
Expression Box
Rick B said:
You could use conditional formatting in the form to do that. You
Click to expand...
would
use
the "ExpressionIs" option and put something like the following in the
expression box:

Code: 
=2 or [Code]=4


Rick B

I'm not sure if this would be achieved in Queries or Forms. What I[/QUOTE] want[QUOTE]
to
do is highlight in red all the fields in a row when the value in the Code
field is 2 Or 4.

Can anyone help?

Bruce
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
AHHHH. I don't know if that is available in A97. Sorry. If so, It would
be on the Format menu.

If not, you would have to put 'if' statements in your forms "on current"
event and also in the "after update" event for the
Code: 
 field.

Rick B



[QUOTE="Bruce"]
Rick where do I find conditional formating tool in Access 97?
[QUOTE="Rick B"]
In conditional formatting, you will click on the first drop-down and select
"Expression Is".  The next field is the box in which you would enter your
expression.

Rick B

[QUOTE="Bruce"]
Thanks Rick,it sounds promising can you expand on it. Where is the
Expression Box
"Rick B" <Anonymous> wrote in message
You could use conditional formatting in the form to do that.  You would
use
the "ExpressionIs" option and put something like the following in the
expression box:

[Code]=2 or [Code]=4


Rick B

I'm not sure if this would be achieved in Queries or Forms. What I want
to
do is highlight in red all the fields in a row when the value in the
Code
field is 2 Or 4.

Can anyone help?

Bruce
[/QUOTE]
[/QUOTE]
[/QUOTE]
 
One of the reasons conditional formatting was introduced in Access
2000 was that, in a continuous form, you cannot format (including
colors) different rows in different ways. Anything you apply is
applied to all rows simultaneously. If this is the situation, I
believe there is no known remedy Access 97, except to get the upgrade
to 2000 or later.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


AHHHH. I don't know if that is available in A97. Sorry. If so, It would
be on the Format menu.

If not, you would have to put 'if' statements in your forms "on current"
event and also in the "after update" event for the
Code: 
 field.

Rick B



[QUOTE="Bruce"]
Rick where do I find conditional formating tool in Access 97?
[QUOTE="Rick B"]
In conditional formatting, you will click on the first drop-down and select
"Expression Is".  The next field is the box in which you would enter your
expression.

Rick B

Thanks Rick,it sounds promising can you expand on it. Where is the
Expression Box
"Rick B" <Anonymous> wrote in message
You could use conditional formatting in the form to do that.  You would
use
the "ExpressionIs" option and put something like the following in the
expression box:

[Code]=2 or [Code]=4


Rick B

I'm not sure if this would be achieved in Queries or Forms. What I
want
to
do is highlight in red all the fields in a row when the value in the
Code
field is 2 Or 4.

Can anyone help?

Bruce
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
 
Try Stephen Lebans' site. The following URL may work for what you want.

http://www.lebans.com/formatbycriteria.htm#Older Timer based versions

Tom said:
One of the reasons conditional formatting was introduced in Access
2000 was that, in a continuous form, you cannot format (including
colors) different rows in different ways. Anything you apply is
applied to all rows simultaneously. If this is the situation, I
believe there is no known remedy Access 97, except to get the upgrade
to 2000 or later.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

AHHHH. I don't know if that is available in A97. Sorry. If so, It would
be on the Format menu.

If not, you would have to put 'if' statements in your forms "on current"
event and also in the "after update" event for the
Code: 
 field.

Rick B



[QUOTE="Bruce"]
Rick where do I find conditional formating tool in Access 97?
"Rick B" <Anonymous> wrote in message
In conditional formatting, you will click on the first drop-down and
select
"Expression Is".  The next field is the box in which you would enter your
expression.

Rick B

Thanks Rick,it sounds promising can you expand on it. Where is the
Expression Box
"Rick B" <Anonymous> wrote in message
You could use conditional formatting in the form to do that.  You
would
use
the "ExpressionIs" option and put something like the following in the
expression box:

[Code]=2 or [Code]=4


Rick B

I'm not sure if this would be achieved in Queries or Forms. What I
want
to
do is highlight in red all the fields in a row when the value in the
Code
field is 2 Or 4.

Can anyone help?

Bruce
[/QUOTE]
[/QUOTE][/QUOTE]
Click to expand...
Click to expand...
 
Back
Top