Conditional formatting expression

  • Thread starter Thread starter Dan Cole
  • Start date Start date
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
 
Dan,

The main problem is in the reference. You should not be referencing the
field in the table, you should be referencing a control in the report! If
you don't already have a control bound to the Rush field in your report,
then add it (and make it invisible if you don't want it to appear). Then the
expression in your conditional formatting should be:
[ctrlRush] = True
where I have assumed that ctrlRush is the name of the control, change as
required. Note also a Yes/No field is of type Boolean, so its values are
True / False. "Yes" is a string!

HTH,
Nikos
 
Back
Top