Problem with Office 2003 SP3

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brossyg - 21 Sep 2007 15:06 GMT

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

Reply to this Message

Pieter Wijnen - 21 Sep 2007 17:10 GMT

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

> 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).
[quoted text clipped - 7 lines]
>
> Brossyg

Reply to this Message

CurtainMary - 31 Oct 2007 23:12 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> Brossyg

Reply to this Message