If account = 180* then background color = 123456

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

Guest

I have a continuous form that is displaying data from different account
numbers. I want a specific account numbers (example 180*) to show up with a
different colored background to highlight them against all the other accounts.

How would I do this?
 
Use conditional formatting. Highlight the control for the account numbers.
Then from the menu Format-->Conditional Formatting. The rest should be self
explanatory.
 
Hi, BLT.

The easiest way is with conditional formatting. Select your control in
Design view, and click Format, Conditional Formatting. Select Expression is,
and type the following expression:

Left(LTrim([AccountID]),3) = "180"

Hope that helps.
Sprinks
 
Back
Top