Conditional Formatting Expression

[ThatNewGuy]

Ok guys, bear with me...I'm new to the world of Access and these are really trivial questions, but I need a helping hand.

I'm using the conditional formatting wizard in Access. I know how to use the formatting options, they're really basic my problem stems from the expression I'm trying to use. I'm looking to apply specific formatting conditions ie bold/red text to a select few product numbers to apply to my reports. Currently I'm using the simple [part #]=556052...now that part works fine once I view it in the report. The format of the part # changes and everything is great. When I try building an expression with multiple numbers the formatting doesn't work anymore. For example, [part #]=556052 then I want to add part #'s 1010894, 1013878, 1016307, etc etc...to the current string.

 

[PHV]

Have you tried this ?
[part #] In (556052, 1010894, 1013878, 1016307)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

You mention a report. With reports you can code in formatting.
Curious if there is conditional formatting in Access 2003
thread702-1323406

 

[ThatNewGuy]

PHV,

Thanks! This was driving me crazy and the only difference was the word "In".

Remou,

I thought I read that conditional formatting started with Access 2000. Check under your format menu for conditional formatting or if you select the item u r working on you can right click and it offers you the option.

Thanks guys

 

[Remou]

I was posting a link to a thread titled "Curious if there is conditional formatting in Access 2003"!