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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using constants as a propoerty value 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Run a form in background using checkboxes on main form 0
cant get cbo to stop outputting key# 0
Excel Numbering rows by font color, but skipping blanks 1
Conditional formatting of a subform's background color 4
Color of a Tab Contol 2
how to change color of control in continuous forms 1

Back
Top