Conditional Display on Continous Form

[esskaykay]

I’m working on an ACC2003 form with conditional formatting set on a couple controls. I’d like to change the back color of one input field based on value in another field. It works fine when running Win2K but bombs on WinXP. One resolution I saw was coding On Activate to Me.Recalc. This resolved one of the problems but not all.

Any suggestions would be greatly appreciated.

Thanks,
SKK

 

[boblarson]

Your problem is likely that until you move the focus elsewhere the value of the control hasn't really changed yet.

 

[esskaykay]

So when I tab to the next field, does the focus change or must that be coded? Tabbing does not change the color.

SKK

 

[boblarson]

So when I tab to the next field, does the focus change or must that be coded? Tabbing does not change the color.

SKK

What did you use for the conditional formatting expression?

 

[esskaykay]

Condition 1
Expression Is [txtPERCENT] < 40

Preview is Disabled

txtPERCENT is another calculated field (or control - not sure of the terminolgy) on the form.

SKK

 

[boblarson]

Try using the actual formula that txtPercent is using like:

[Field]/[Field2] < 40

 

[esskaykay]

I'll try that. It's actually quite involved because there are a few other conditions that have to be met, but I'll keep you posted

Thanks again...
SKK

 

[esskaykay]

Bob,

I believe I found my problem. On the first tab after the one in question, I added Me.Recalc for the Got Focus control. It appears to be working.

Thanks for your suggestions...
SKK