RE: Data not displaying in combo list box

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi Lori,

I don't know, but it just started happening with the release of SP3. As Ken
mentioned, they've had many users report it during the past week.

In my case, I have temporarily removed the formatting I had appled to the
bound field, and it's working again now as it should.

You can see my thread "Microsoft Access Combobox with SP3" in this same forum.

Like you, I hope they fix it soon - but most likely it'll be included in the
October "Patch Tuesday" release.

Have a nice day!
--
Karl


"Lori" wrote:

Karl,

Thanks so much for the response. Any idea how long they have been working
on this problem? Just wondering if I should unistall Office 2003, reinstall
and only go as far as SP2.
--
Lori


"Karl" wrote:

Lori,

I also had the same problem and received this response from Ken Snell (MVP).
My message is also shown here.

Subject: Re: Microsoft Access Combobox with SP3 9/25/2007 9:47 AM PST

By: Ken Snell (MVP) In: microsoft.public.access.forms


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.

--

Ken Snell
<MS ACCESS MVP>


"Karl" <Karl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6D011E4-18C4-48B4-9CA2-71167A53F9B1@xxxxxxxxxxxxxxxx
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.

--
Karl

--
Karl


"Lori" wrote:

Since installing Office Service Pack 3, my combo list boxes do not display
properly. Some only have data in 1 of 2 columns displayed on the form, some
have no data in either of the columns displayed on the form. However, when I
go into design view and open the source table, the data is there....for some
reason it is not displaying on the form. Have been using these same forms
for 10 years. Must be a conflict with a security update?

Can anyone offer assistance?
--
Lori
.



Relevant Pages

  • Re: SP6 is that all?
    ... >>He indicates a nasty bug associated with the ListView control that was ... One of my machines is still on SP3 as well. ... My others are on SP5 and I don't plan to apply SP6 anywhere any time soon. ... I applied for the beta of SP6 months ago, *As an MVP*, but when they simply ignored ...
    (microsoft.public.vb.general.discussion)
  • RE: Windows XP SP2 Wont Install
    ... Did you know SP3 is now available? ... TaurArian [MVP] 2005-2009 ... "Jessica" wrote: ...
    (microsoft.public.windowsupdate)
  • Re: Create popup word definitions on click
    ... I'm using Word 2002 with SP3 ... Herb Tyson MS MVP ... Please respond in the newsgroups so everyone can follow along. ...
    (microsoft.public.windowsxp.general)
  • Re: Running a .NET 1.0 application on Windows.NET CE version 5.0 (CE5)
    ... Ginny Caughey [MVP] wrote: ... work, and eventually posting here, 2mins later we got it working by retoring the unti to it's factory default ... The device came with .NET v1.0 SP3, but the distributor put v2.0 on it, we then put v1.0 on it, as part of our usual installation, and I imagine it got in quite a muddle. ...
    (microsoft.public.dotnet.framework.compactframework)