Hi, Karen - as a work around you could always run this command once on
the column.
UPDATE Table SET Freight = (LUC(Freight))
Albert
On 09/12/2010 12:15 PM, [email protected] wrote:
I have a DB Radio Group on my form. The column it refers to is
"Freight". The radio button values in the control's tab show this:
Caption Value
Prepaid PREPAID
Collect COLLECT
Because the data is old, the column's data is mixed-case: PREPAID,
prepaid, Prepaid...
However, the radio group seems to be case sensitive. It will only
show as being checked if the value is upper case, like the column on
the right. I have verified that the general setting CASE is OFF. Is
there another property setting I'm missing in this control or outside
to tell it to ignore the case? Otherwise I might report this as a
bug, but wanted to check first.
Thanks!
Karen
