If account = 180* then background color = 123456

B

BLTibbs

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?
 
K

Klatuu

Use conditional formatting. Highlight the control for the account numbers.
Then from the menu Format-->Conditional Formatting. The rest should be self
explanatory.
 
S

Sprinks

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
 
Top