Conditional Formatting for colors

artregdlg

New member
Local time
Yesterday, 16:39
Joined
Aug 23, 2013
Messages
7
I have an access form that has a dropdown box list of 10 choices.
for example:

The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.

They choose 5, 6, 7 or 8 Then it need to print in RED.

So forth and so on.

I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.

I do not know how to use VBL or coding.

Any help would be greatley appreciated

Regina
 
You might find

[FieldName] < 5

easier, but if your situation is more complicated

[FieldName] = 1 Or [FieldName] = 2 Or...
 
I am not really sure where I should put the formula that you are referring, and maybe I am not really clear in my description.

=====

I am making a parking pass for over 10,000 employees.
In the parking pass there will be a drop down menu that classifies various places to park.
The label is TYPE.

The choices in the drop down are:

Executive, Semi-Executive, Director, Carpool, Vanpool, Motorcycle, Disabled, and Visitor.

The choices need to print a particular color when chosen:
Executive, Semi-Executive will print red.
Director, Car pool will print blue.
Van pool, Motorcycle will print green.
Disabled, visitor will print yellow.

I know I can use conditional formatting to make the colors/font/size/style for each drop down but I am limited to three conditions, and only three words

I was wondering how i can use the conditional formatting to state something like:
=IF "EXECUTIVE" OR "SEMI-EXECUTIVE"

To allow for each choice to print in each color required.

I hope this is clearer?

Thanks for any help clearing up my confustion..
 
That was intended to be an expression in Conditional Formatting. You are limited to 3 conditions, but the default makes 4. You are certainly not limited to 3 words, if you use Or as I demonstrated.
 
First thanks Paul for all the help, and being so patient with me and all my questions.

I feel that I have a really good grasp on Microsoft Access, however my supervisor wants more in the program than I have ever learned or taught myself.

So if I am understanding properly then the expression should be something like this?

[TYPE] = EXECUTIVE OR [TYPE]= SEMI-EXECUTIVE

(assuming that I do need the [ in each expression, and the spaces like above)

Additionally, I do not need any pronunciations in the expression, correct?
 
Because the values are text you need quotes around them, as you have above.
 
I will try this on Monday and let you know how it worked out.
THANKS
 
THANK YOU SO MUCH....I almost did not figure it out but then I realized it was a expression not a field value. You just make me look very professional!
 

Users who are viewing this thread

Back
Top Bottom