Access - Service Pack 3 issues

[hdfixitup]

I installed Office Service Pack 3 and display issues in Access have
debveloped. I have several combo boxes on forms that perform lookups in
different tables and noticed on several (not all) that when I click on the
down arrow in the box, not all data is displayed in the columns. Some
columns are entirely empty, whoile others are populated. I run the query by
itself and all data is retrieved and all is displayed. Why would some
columns only be displayed and then some combo boxes are working properly? I
tried the same database on another computer without SP3 and all works fine.
I removed Office 2003 entirely and reinstalled - checked the same - NO
problems. I reinstalled SP3 and problems are back immediately. I removed
again and reinstalled Office 2003 and then SP2. NO problems. Any ideas on
SP3 bug or maybe I should just can the SP3 update. Any help would be
appreciated.

 

[mezzodiva]

Hi, hdfixitup,

This is a commonly-reported issue with SP-3. You may want to hang out in the
Access newsgroups to find out other workarounds, but here's one from an MVP:

In the meantime, an MVP has suggested this as the workaround -- use an
SQL
statement similar to this in the combo box's RowSource property:


SELECT FieldX & "" AS NewFieldX
FROM TableName;