Data in combo box not visible

[Don Barton]

I have a form with a combo box on it, and it has worked flawlessly for
sometime. Now, when I go to make a selection in the combo box, I see
nothing but white. The list pulls down to 8 data items (as
programmed) but there appears to be nothing there. But, when I select
on "nothing", the data is selected. So if I go to position 3 in the
combo box drop down list, I get the correct 3rd item. But I can't see
anything in the drop down list. The resulting data selected does show
up correctly in the main combo box field, but I can't see what I am
selecting until after it is selected.
Using the wizard, the same thing happens.
The query that the combobox uses works correctly.
Is this a bug? Anyone else ever experience this?
Access 2003

Of course this happens the day before I am suppose to do an install...

Don

 

[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. It apparently
is a bug in Office 2003 SP3, which was released by MS about a week ago. MS
is aware of the bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view.
Otherwise, concatenating the field's value with an empty string also seems
to "overcome" the problem.

 

[Guest]

Don:

Go into the form in Design View and click on the combo box. Go to the
COLUMN WIDTH property and double-check to make sure that the widths are set
appropriately.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

 

[Don Barton]

Hi Bob,
I actually checked that out using different size of column widths, and
that did not fix the problem. I could see the width when I accessed
the combobox, but no data for my text field. If I used another field,
I could see the data. I think Ken suggestion is correct, as I do have
the formatting ">" set for the field I couldn't see. This formatting
symbol ">" has caused it's share of problems in the past especially
when it truncated memo fields.
Thanks,
Don

 

[jeffd]

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. It apparently
is a bug in Office 2003 SP3, which was released by MS about a week ago. MS
is aware of the bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view.
Otherwise, concatenating the field's value with an empty string also seems
to "overcome" the problem.

--

Ken Snell
<MS ACCESS MVP>








- Show quoted text -

I am having the same problem. I used Ken's suggestion to remove the
">" symbol, and it does not work. I am cursing upgrading to SP3
yesterday. Any additional suggestions that don't involve uninstalling
Access and re-installing to SP2?
The concatenation of an empty string is not really an option either
because of additional programming downstream.....

 

[Ken Snell \(MVP\)]

Did you remove the Format property from both the field in the table and from
the combo box in the form?

 

[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

 

[Matthew Martin]

I have a different problem. My Combobox shows the correct data and delivers the correct info to each field that gets filled after my selection. The issue is some of the fields are not visible. They are entered but invisible.

 

[Arvin Meyer [MVP]]

I have a different problem. My Combobox shows the correct data and
delivers the correct info to each field that gets filled after my
selection. The issue is some of the fields are not visible. They are
entered but invisible.

Make sure that there is a setting in the column count property sufficient to
display all the columns, and that their columnwidth property is not set to
0.