Access List Box lost format

[Bird Byte]

After installing Office SP3 a Yes/No column in a listbox shows -1 or 0.
The field properties set in the table are: data type is Yes/No; format is
Yes/No; Lookup Display control is a check box.
The list box properties are: Row Source Type Table/Query; Row Source is a
select statement >> SELECT Table1.Field1, Table1.Field2, Table1.Field3,
Table1.Field4, Table1.Field5 FROM Table1 WHERE (((Table1.Field4)='" &
Me.txtField4 & "')) ORDER BY Table1.Field1, Table1.Field2;

Field3 is the field not displaying properly.

 

[boblarson]

This is a known bug in SP3. Remove any formatting at table level and you
should be good. (If I remember correctly).
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Bird Byte]

Thanks very much for the info, if it happens again I'll give it a try. I
ended up doing a re-install of office 03 and applied service pack 2. I'm
going to test service pack 3 on my own machine next week and I will test your
formatting suggestion.