Set format property on report based on combo box selection

[cdgeer]

Hello,
I'm trying to set the Fore Color (or Back Color) of a Report field based on the value in another. Basically, I have a combo box on a Form say... [cmbColor] that offers Red, Blue or Green to select from. I have a Report that runs off a Query of that Form's underlying Table. I want to set a date field's [ExtDate] format property on that Report based on the combo box selection.
I've tried creating a Macro (which I'll admit I don't have much experience with, and keep getting Type Mismatch problems) and tried writing VB but can't seem to get that syntax to come out right either. I was trying to use the Report's OnLoad argument but...
Please help?

 

[PHV]

Did you try conditional format (no code needed)?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cdgeer]

Thanks PHV.
You know I just started using Access 2013 and also have been away from Access for a couple years but, I tried selecting the conditional formatting from the top menu when I had the field highlighted (and in Design view of course) but it wouldn't open up. However, I just now found that if I right click on the field instead..... no problem.

My inadequate navigational skills cost me about 3 hours this morning. :/