RE: Data not displaying in combo list box

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

"Karl" wrote:

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: Lost welcome screen XP
    ... I'm running SP3. ... I was hoping that SP3 would fix it. ... have already tried the control panel "change how users log on" choices, ... Kelly's corner fix, and the DougKnox tool. ...
    (microsoft.public.windowsxp.basics)
  • Re: Lost welcome screen XP
    ... I tried that but unfortunately I have SP3 installed, ... Also noticed my windows insttaller doesn't work. ... run because it says windows installer is not working or something. ... I was hoping that SP3 would fix ...
    (microsoft.public.windowsxp.basics)
  • Re: Combo box in a Form
    ... At worst, you could uninstall Office 2003, and take the service patches to SP2 only. ... However, all my databases work with SP3, so it should be possible. ... I could upgrade to Access 2007: would that fix the problem? ... There are known problems with this service pack, including blank columns in the combo if you have anything in the Format property of the field in your table. ...
    (microsoft.public.access.forms)
  • Re: Screen wont scroll properly
    ... I, too have a thinkpad, SP3, windows xp, newly formatted. ... Changing browsers doesn't fix it. ... 'something' happens and when I try to scroll ...
    (microsoft.public.windowsxp.general)
  • Re: drop down list stopped working
    ... HAS ANYONE OUT THERE HEARD ANYTHING FROM MS YET ABOUT HOW TO FIX THIS? ... "Ken Snell " wrote: ... <MS ACCESS MVP> ... is a bug in Office 2003 SP3, which was released by MS about a week ago. ...
    (microsoft.public.access.forms)