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).