Bizzare control color behavior

[Max Yaffe]

Dear Group,
I've got a rather bizzare bit of control behavior that I need help to
understand.

I have a form with two controls, a textbox called txtList and a toggle
button called tglFinagle. txtList is bound to a field "List" in an
SQL table. tglFinagle is bound to another, integer, field, "Finagle"
in the same table.

Here's the behavior: When Finagle is True, txtList shows with a
Yellow background. When Finagle is false, txtList shows up White.
There is not any code that causes this change. As a matter of fact,
BackColor doesn't show up in any code. There are no macros. There
are no SQL server procedures active. The table is linked via ODBC.

It is as though there is a hidden statement like
myForm.txtList.BackColor = iff([Finagle], colorYellow, colorWhite)

but I can't find the darn thing!

Please help an aging programmer maintain his sanity.

Max

 

[RoyVidar]

Dear Group,
I've got a rather bizzare bit of control behavior that I need help to
understand.

I have a form with two controls, a textbox called txtList and a toggle
button called tglFinagle. txtList is bound to a field "List" in an
SQL table. tglFinagle is bound to another, integer, field, "Finagle"
in the same table.

Here's the behavior: When Finagle is True, txtList shows with a
Yellow background. When Finagle is false, txtList shows up White.
There is not any code that causes this change. As a matter of fact,
BackColor doesn't show up in any code. There are no macros. There
are no SQL server procedures active. The table is linked via ODBC.

It is as though there is a hidden statement like
myForm.txtList.BackColor = iff([Finagle], colorYellow, colorWhite)

but I can't find the darn thing!

Please help an aging programmer maintain his sanity.

Max

Is it someone else who has designed it? Try selecting the control, then
enter format | conditional formatting, and see if there's anything
there.

 

[Max Yaffe]

Nevermind. I found it. Conditional Formatting! What a kludge!
Hiding out in the Format menu while I'm breaking my eyes going through
all my code!

Sigh.
Max