Problem with Office 2003 SP3

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
This is an introduced bug with the SP3. Other columns with formatting will be
blank, eg > for capitalization. Blame MS !!
Mary
 
Back
Top