Lose formatting in listbox

[Guest]

We have a listbox with several columns that populate when the form loads. One
column has a yes/no data type and it gets its value from a check box. The
list has always read "Yes" or "No", but now it's listing the -1 or the 0. I
changed the field's format from true/false to yes/no, but that had no effect.
I also tried formatting the row source using "Iif" (ColumnName: iif([Field],
"Yes", "No"), but that had no effect.

The data sits on a 2000 Server, the clients have XP w/Office 2003. The
machines were put in production 5 months ago with no problems. The old
machines were 2K Pro with Office 2K.

Thanks very much for any ideas/help.

 

[Wolfgang Kais]

Hello BirdByte.

We have a listbox with several columns that populate when the form
loads. One column has a yes/no data type and it gets its value from
a check box. The list has always read "Yes" or "No", but now it's
listing the -1 or the 0. I changed the field's format from
true/false to yes/no, but that had no effect. I also tried
formatting the row source using "Iif" (ColumnName: iif([Field],
"Yes", "No"), but that had no effect.

You said that when the form loads, the listbox is populated, so maybe
the rowsource of the listbox is changed through code. You should find
the code and change it to use the iif function.

 

[Guest]

Thanks for the suggestion. I did try changing the row source in code but it
didn't solve the problem. What did solve it was uninstalling Office 2003
(which subsequently uninstalled Office 2003 sp3) and reinstalling it. Once
sp3 went away everything was dandy.

Hello BirdByte.

We have a listbox with several columns that populate when the form
loads. One column has a yes/no data type and it gets its value from
a check box. The list has always read "Yes" or "No", but now it's
listing the -1 or the 0. I changed the field's format from
true/false to yes/no, but that had no effect. I also tried
formatting the row source using "Iif" (ColumnName: iif([Field],
"Yes", "No"), but that had no effect.

You said that when the form loads, the listbox is populated, so maybe
the rowsource of the listbox is changed through code. You should find
the code and change it to use the iif function.

 

[Wolfgang Kais]

Hello "Bird Byte".

We have a listbox with several columns that populate when the form
loads. One column has a yes/no data type and it gets its value from
a check box. The list has always read "Yes" or "No", but now it's
listing the -1 or the 0. I changed the field's format from
true/false to yes/no, but that had no effect. I also tried
formatting the row source using "Iif" (ColumnName: iif([Field],
"Yes", "No"), but that had no effect.

You said that when the form loads, the listbox is populated, so maybe
the rowsource of the listbox is changed through code. You should find
the code and change it to use the iif function.

Thanks for the suggestion. I did try changing the row source in code
but it didn't solve the problem. What did solve it was uninstalling
Office 2003 (which subsequently uninstalled Office 2003 sp3) and
reinstalling it. Once sp3 went away everything was dandy.

You are right. When I answered your post, I tested changing the format
using SP2. Later that day, the installation of SP3 was inforced on my
laptop by a new update policy my boss decided to implement. Now I can
feel with you.