Wierd Conditional Formatting error

[laughingdevil]

Hi, hopefully someone can shed some light on this.

I have a form in Access 2002 with about 20 text boxes with data from a table. I have conditional formatting set up on several of them so.

One of the boxes has this format set

"[POPFLAG]<>0 And [diagpopcount]>0"

Popflag is another box, and diagpopcount is the box in question, the formatting is supposed to turn it red if the pop flag box contains anything other than 0 and the diagpopcount is >0.

If I load the form with popflag =0, then change it to 1 this works fine. However If I load the form with popflag =1 then the formatting is not applied (there is no other format applied to the box) and I've no idea why.

To make things more wierd if I apply this format to another box, not only does it work correctly on that box, but the formatting on the diagpopcount box starts working too!

Currently I have a workaround where I have the clause on another box set to do nothing, however I may need to put more formatting on this in future so don't want to "eat up" my format count, and also I don't like having this code sat around when it shouldn't be needed.

Any assistance would be appreciated.

 

[alansidman]

Try putting this in the after update event for the popflag control:

me.requery

Alan

 

[laughingdevil]

Not quite sure what you mean.

I'm not doing the conditional formatting in VB, just in the normal format>conditional formatting, not sure where you'd put me.requery their.

I have tried sticking that in the forms "on open" code, but this doesn't work either.

 

[laughingdevil]

Note : I have another text box called Pop2Count, which has exactly the same conditional formatting statement as Diagpopcount, which works on open.

 

[alansidman]

Open your form in design view. Right click on the popflag textbox. Click on Properties. Click on the After Update on the Event tab. Insert the code there.

Alan