One column of a list box does not display for all users.

M

mike1969

I have a list box on a form that displays two columns of information from two
columns of a table. The main column contains material numbers and this is the
information that actually populates the box when selected. The other column
is a description that goes with the material number. On on everyone elses
computer the main column (material number) apears to be empty and only the
descriptions are displayed. On my computer the list box works fine with
everything displayed as it should be. It seems that it must be a setting, but
I cannot find one. Does anyone have any idea of what could be causing this?

We are using Access 2003.
The database was created in Access 2000 and converted to 2003
 
L

Linq Adams via AccessMonster.com

My guess would be that the errant PCs have been updated to the SP3 service
pack and it's buggier than the Great Dismal Swamp! One of the most common
bugs reported involves comboboxes with disappearing data! Sound familiar? The
"disappearing" field(s) in the underlying table have some kind of formatting
in place.

This is often the simple > used to force UpperCase. Remove any formatting
from the fields and things should work short term, but the definitive
solution is to install the hotfix for SP3. Here’s the link for the hotfix:

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

mike1969

Widths seem to be set properly. I even made a whole new box with the wizard
and the new one has the same problem. What I do not understand is how it will
work on one machine and not another.
 
R

Rick Brandt

mike1969 said:
Widths seem to be set properly. I even made a whole new box with the
wizard and the new one has the same problem. What I do not understand is
how it will work on one machine and not another.
Click to expand...

Service Pack 3 for Office 2003 introduced this bug and a later patch fixed
it. Either your machines that work are pre-SP3 or they have the patch
installed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Setting column width in a table with a macro is not working 0
Creating a Search using a combo box and then creating a report. 4
MS Project Import Error Row 1 Column 5 2
Format column widths from one table to a separate table on same page 1
Set as Default Template not working 0
Unable to display values in 2nd list box from 1st list box selection 2
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top