Microsoft Access Combobox with SP3

[Guest]

I have an access database that contains a form with a ComboBox on it. That
box is populated from a table in the database.

It has been working for many years now, but after the latest MS Update that
applied Office SP3, the ComboBox is no longer populated - it's just a blank
ComboBox.

I attempted to create a new ComboBox using the wizard, but got the same
result.

Can anyone else confirm this and/or supply a possible solution?

Thanks.

 

[Ken Snell \(MVP\)]

By chance, the field to which the combo box is bound is a text field and has
a Format property setting for the field in the table? If yes, this is a bug
that has been reported by many ACCESS users during past week. MS is aware of
the bug and is working on how to fix it.

 

[Guest]

HAS ANYONE OUT THERE HEARD ANYTHING FROM MS YET ABOUT HOW TO FIX THIS? I NEED
HELP QUICK...WE HAVE BEEN HAVING SERIOUS PROBLEMS SINCE THURSDAY (9/27/03)
WHEN OUR AUTOUPDATES INSTALLED OFFICE SP3...

 

[Ken Snell \(MVP\)]

One post in the group is quite sufficient, thank you.

 

[Guest]

My apologies...I wasn't sure how often or who checked what strings...I just
wanted to get my request out there so someone would see it... I'm sorry

 

[joekool1]

One post in the group is quite sufficient, thank you.

--

Ken Snell
<MSACCESSMVP>






- Show quoted text -

Here is the solution until the bug is fixed... (this does work)
---------------------------------
I have not installed SP3 for ACCESS 2003 yet, but I've asked fellow
ACCESS
MVPs to check this out.

So far, it doesn't appear to be found with Vista operating system.

But reports about this behavior are being made in the Italian
newsgroup, and
has been confirmed by one MVP in Polish version of ACCESS. There
likely will
be additional results (good or bad) in the near future.

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;

Let us know if this workaround gives you back the formatting display
characteristics.

--

Ken Snell
<MS ACCESS MVP>

=================
Joe K

 

[Guest]

I too am having this problem since we updated to SP3 last night (Vista not
installed). On our forms, only one out of many combo boxes is having this
problem. The others work fine.

I will try the temporary fix mentioned but I hope a solution comes soon.

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

JohnMc

 

[Ken Snell \(MVP\)]

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

 

[pcbins]

It it almost a year now since this post. the service pack did not work for
all of my databases. Even within the same database, some combo boxes work
right and some dont... I am sure there are others who are having the same
problem. Is there a fix for the fix yet?

 

[Keithr]

Forgive the late addition to this post, but I've recently experienced
problems with Access 2003 after the pos-SP3 hotfix was installed. This was
specifically in conjunction with linked tables in SQL Server and was fixed by
installing Windows XP SP3. I suspect that XP SP3 updates the MDAC
components. Hope that helps with any difficulties others may still be
having.