Highlighting on Continuous Forms

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

Is there any way to highlight an item on a Continuous Form
based on criteria in Access 2000? What I would like to do
is have an items backcolor change if (for example) the
item price > X dollars. I know you can do this on a
Single form by using the ON CURRENT event, but I am
looking for a way to do this on a Continuous form.

Thanks in advance for any assistance!
 
Joel,
Use the Conditional Formatting property for that control.
Select the control.
Click Format + Conditional Formatting
Set the Condition 1 drop-down to
Expression Is
In the text box alongside the drop-down write:
[Item Price] > 100 (or whatever X is suppose to be)

Set the appropriate color.

Click OK.
 
Back
Top