Conditional Formatting ? or VB? (1 Viewer)

[basshead22]

Hello All,

Its been awhile since ive been on here. You guys are always really helpful.

I have a timekeeping report in which I want to format or force a zero value if a certain project number is picked. For instance on Monday John Doe charged 6 hours to project NNNNN but on the report rather than show 6 hours I want it to show 0 hours. I know doesn't make sense but project NNNNN is non billable so we want to track the 6 hours in the db but on the report we want to show 0 hours. So can I write a conditional formatting expression in my report to do so??? or its it more complicated than that?

thank you in advance!

 

[pbaldy]

My first thought is a formula in the source query:

IIf(Project = "NNNNN", 0, HoursField)

 

[CJ_London]

conditional formatting refers to the font colour/bold/underline, the back colour and the enabled state.

If you want it to display 0 then Pauls suggestion is the way to go. If you want it to appear blank then you can use conditional formatting to set the forecolour the same as the backcolour.