Conditional Formatting not working in a Form

[MsT]

I have a form and the conditional formatting does not work consistently.

It’s a columnar form with tabs within it. It was created from a wizard originally and then heavily modified (both the layout of the form and also the underlying query created by the wizard)

When I open the form, the CF does not work. After I open the form in design view, open the underlying query, and close it again, the CF works.

All the CF fields are affected, both those in the form header and those in the tabbed sections.

I originally thought it was linked to the fact that the fields were calculated, but I've tried with simple numerical fields and they are affected too.

Has anyone any suggestions or solutions?

Many, many thanks

 

[Micron]

Without being able to look at the form, this is just a guess. I suspect that the cf would work even if you don't open the query, but just switch the form to design and back again. If that's the case, it seems that at the end of the form load event, you need a form method to force recalculation on the controls. I'd try (in this order but one at a time) Me.Recalc, Me.Repaint, Me.Refresh, Me.Requery
Don't do this in the form open event, as the load event occurs afterwards. The recalc method is supposed to be for calculated controls, but I'd consider conditional formatting to be a form of calculation but can't say if that's exactly true.

All assumes that we're not talking about a subform here.

 

[MsT]

Me.Recalc in the form load event has fixed it. Thank you very much!