Conditional formatting expression

D

Dan Cole

I'm fairly inexperienced with Access, so I'm sure there's
an easy solution to this.

I have a report called Unfilled, which gets its
information from a query called Unfilled. I have two
tables called Orders and Items. In the Orders table is a
yes/no field called "Rush" that indicates that the client
wants the order in a hurry. I want to set up the Unfilled
report so that when "Rush" is checked, the entire line in
the report (which includes order number, the item being
purchased, and special instructions), shows up as
highlighted in yellow.

I clicked on the "Order Number" field (which is stored in
the Orders table) in the report, and clicked on
Conditional Formatting. I chose "Expression Is" and
entered the expression:

[Orders].[Rush]="Yes"

and set my background color. But when I try to view the
report, it brings up a dialog box called "Enter Parameter
Value" that says "Orders." No matter what I type in it,
nothing seems to get highlighted, and there are definetely
orders where "Rush" is set to "Yes."

PLEASE HELP! Thanks
 
F

fredg

I'm fairly inexperienced with Access, so I'm sure there's
an easy solution to this.

I have a report called Unfilled, which gets its
information from a query called Unfilled. I have two
tables called Orders and Items. In the Orders table is a
yes/no field called "Rush" that indicates that the client
wants the order in a hurry. I want to set up the Unfilled
report so that when "Rush" is checked, the entire line in
the report (which includes order number, the item being
purchased, and special instructions), shows up as
highlighted in yellow.

I clicked on the "Order Number" field (which is stored in
the Orders table) in the report, and clicked on
Conditional Formatting. I chose "Expression Is" and
entered the expression:

[Orders].[Rush]="Yes"

and set my background color. But when I try to view the
report, it brings up a dialog box called "Enter Parameter
Value" that says "Orders." No matter what I type in it,
nothing seems to get highlighted, and there are definetely
orders where "Rush" is set to "Yes."

PLEASE HELP! Thanks
Click to expand...

Two things.

1) A Yes/No field's value is a number, -1 (if checked), or 0 (not
checked).
The -1 value can be expressed using the words True, Yes, or On.
Notice there are no quotes around those words, as they are not
strings.
So, at the very least, your expression value should read
= Yes

2) Isn't the [Rush] field already included in the record source of the
report? It should be.
If it isn't, go on back to the query and add it.
Then you don't use [Orders].[Rush] = Yes.
Simply
[Rush] = Yes.
 
Top