Bizzare control color behavior

  • Thread starter Thread starter Max Yaffe
  • Start date Start date
M

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
 
Max Yaffe wrote in message said:
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
Click to expand...

Is it someone else who has designed it? Try selecting the control, then
enter format | conditional formatting, and see if there's anything
there.
 
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
 
Back
Top