View Full Version : record conditional formatting


mattmill30
07-14-2008, 12:29 AM
I have a report that displays cartridge stocks..

The fields are as follows:

Model, Make, Type, Stock

I'm hoping to highlight the records displayed on the report with stock equal to 0..

Is it possible..

Thanks, Matt

pbaldy
07-14-2008, 07:12 AM
Sure; have you looked at Conditional Formatting (Format/Conditional Formatting)?

pam0566
07-18-2008, 12:16 PM
Ok found that. i have a combo box field [cboagent] which is linked to control source [agent] i am trying to do the conditional formatting using expression, so that if the agent field contains "agent" then {our code for need an agent} then the display would be in red font. i am using the expression: [agent]= Like "*" & "agent" & "*" --- but getting a syntax error. this is the same expression i use to generate a report of those dealers. any ideas?

pbaldy
07-18-2008, 12:36 PM
Drop the = (it's Like or =, not both).

pam0566
07-18-2008, 12:54 PM
Perfect!!! Thanks!