Access 2003 display problem after SP3

[Sander]

Hello all,

I hope someone can help me with the following problem; my database (I use
Dutch A2003 SP3) has some auto increment fields that are formatted on table
level like for example "\E@@@@@". After installation of Office 2003 SP3 these
fields were not displayed any more in listboxes on forms ! Second problem is
Yes/No fields, these now show (again after SP3) 0 and -1 instead of Yes/No in
listboxes. Is this an error in SP3? I tried the format function and fixed the
0/-1 display error, but I do not know how to repair the other error. I would
really appreciate your help!

Thanks,

Sander

 

[Allen Browne]

Sander, this is indeed a bug in A2003 SP3. The combo shows nothing at all if
it is bound to a Text field that has something in the Format property in the
table.

The simplest workaround is to clear the Format property of the field in the
table, and use the Format property of the combo on the form instead.