Problem with Office 2003 SP3

[Guest]

In Access 2003, I have a Combo box in a form with one of the columns
formatted Yes/No (the table the data comes from is also yes/no data). When
the Combo Box was dropped-down, the column correctly showed "Yes" or
"No"...until I installed Office 2003 SP3. Now, the column shows "-1" or "0"
now matter that the format property is set to "Yes/No".

Has anyone else experienced this and found a solution?

Brossyg

 

[Pieter Wijnen]

Change the SQL To
Rowsource:
Select MyField, Format(MyField,"yes/no") As Display From MyTable
change the column count to 2 (rather: add 1)
change the column widths to 0;1cm

HTH

Pieter

 

[Guest]

This is an introduced bug with the SP3. Other columns with formatting will be
blank, eg > for capitalization. Blame MS !!
Mary