Combo Box Problem

[Bob Quintal]

Background:
Using Access 2003. Database is split. Front End is on six office
PC’s. One field is a combo box used to look up apartment
numbers. (This is the general point of reference for our work.)
When the correct apartment is located and selected the underlying
table populates five fields: Apt, Last Name, First Name, Phone and
Company number. The query that supports this action has six
columns with the first column containing the Resident’s ID. The
first column width for this combo box is marked 0 to hide the
Resident ID and store it in the database instead of the related
information. We have been using this like a charm for about two
years.

Problem: The combo box mentioned on one of the six PC’s will
not show the apartment number column or the telephone column. All
of the other PC’s are fine.

Tried: Deleting and creating another combo box; checked all of
the control’s properties to see what may have been changed, etc.
and nothing seems out of place. Copied one of the Front Ends that
works and put it on the affected PC and it did the same thing.

Any thoughts or suggestions would be appreciated.

(snarky answer)
Upgrade the other 5 computers to Microsoft Office Service pack 3.
Then they'll all have the problem until Microsoft releases a patch.

(useful answer)
Temporary workaround: remove the format properties from any tables
that feed your comboboxes, where the table field is type text. .

 

[sid2]

Background:
Using Access 2003. Database is split. Front End is on six office PC’s. One
field is a combo box used to look up apartment numbers. (This is the general
point of reference for our work.) When the correct apartment is located and
selected the underlying table populates five fields: Apt, Last Name, First
Name, Phone and Company number. The query that supports this action has six
columns with the first column containing the Resident’s ID. The first column
width for this combo box is marked 0 to hide the Resident ID and store it in
the database instead of the related information. We have been using this
like a charm for about two years.

Problem: The combo box mentioned on one of the six PC’s will not show the
apartment number column or the telephone column. All of the other PC’s are
fine.

Tried: Deleting and creating another combo box; checked all of the control’s
properties to see what may have been changed, etc. and nothing seems out of
place. Copied one of the Front Ends that works and put it on the affected PC
and it did the same thing.

Any thoughts or suggestions would be appreciated.

 

[sid2]

Background:
Using Access 2003. Database is split. Front End is on six office

[quoted text clipped - 19 lines]

Any thoughts or suggestions would be appreciated.

(snarky answer)
Upgrade the other 5 computers to Microsoft Office Service pack 3.
Then they'll all have the problem until Microsoft releases a patch.

(useful answer)
Temporary workaround: remove the format properties from any tables
that feed your comboboxes, where the table field is type text. .

Thanks...I will give that a try!