Conditional Formatting... Help please!?

[pantscat]

Hello everyone!

I'm somewhat of an Access newbie... used it a bit in the past, but never to do anything what I would describe as clever.

I'm trying to use conditional formatting to change a bound text box on a report to a different BackColor.

E.g. when the bound field is blank leave the BackColor as black, if the field has a text string (which is always going to be 2 or 3 chars) then change the BackColor to white.

I would really appreciate any advice anyone could offer.

Ta,

Ant

 

[brewpedals]

Hi Pantscat,

I am working on the same problem with limited success.

I started by creating an unbound "hilite" control with it's visable attribute set to No and placed behind my bound control.

I created a macro to Open the report, then set of a the value of the visable attribute to Yes on the "hilite" contol, using an IIf statement in the Expression field of the macro builder.

Here is my if statement:

IIf([Reports]![R_Capital Project Summary >$1M]![focus]=Yes,Yes,No)

"[focus]" is a check box contol bound to a yes/no field in the report query.

If I set the macro's expression to from my iif statement to "yes" all records are hilited as designed.

My problem is that macro/iif statment sees the value of the checkbox as "No" regardless of the value of the yes/no field in the query.

Can anyone out there give us hint.

Thanks.