Office 2003 SP3 changed lookup field format

[Gene]

In machines that I applied Office 2003 SP3 my Access DB lookup fields that
should have a Yes/No formated columns have changed to 0 and -1. On the
machines that I have not yet gotten to this has not happened. I can't
uninstall the update so how can I fix this short of uninstalling and
reinstall the whole Office 2003 Pro suite?

I looked at the underlying queries and they are formated correctly. It is
only on the form that the format has changed.

Thanks,
Gene

 

[boblarson]

1. Remove any formatting at table level and apply formatting at FORM level.

2. If you are using lookup fields within your tables, get rid of them. See
here for more information:
http://www.mvps.org/access/lookupfields.htm

http://dbageek.blogspot.com/2004/10/access-web-evils-of-lookup-fields-in.html


--
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.