Listbox, Dropdownbox, Data in one column not visible

[Doekoe]

We use MS Access for our Account Managers, we work with a front.mdb
and a back.mdb. At some point in time (say two weeks ago) a listbox
shows all records however one column (field) is not filled. The source
for this listbox is a query. When I run the query, it shows all
records and all data in all columns.

The same for a dropdown box, this will show all records but this
specific column shows no data although there is data.

I deleted all records from the table and entered a new record. All
fields are filled in the table and also in the query, however opening
the listbox shows all fields except the one. There is some strange
connection between the controls (listbox and dropdownbox) and this
field in the query or table. However I can not figured it out.

Hope someone recognize the problem and can give some help.

Thanks in advance,

Dirk

 

[Rick Brandt]

We use MS Access for our Account Managers, we work with a front.mdb and
a back.mdb. At some point in time (say two weeks ago) a listbox shows
all records however one column (field) is not filled. The source for
this listbox is a query. When I run the query, it shows all records and
all data in all columns.

The same for a dropdown box, this will show all records but this
specific column shows no data although there is data.

I deleted all records from the table and entered a new record. All
fields are filled in the table and also in the query, however opening
the listbox shows all fields except the one. There is some strange
connection between the controls (listbox and dropdownbox) and this field
in the query or table. However I can not figured it out.

Hope someone recognize the problem and can give some help.

Thanks in advance,

Dirk

Are you using Access 2003 and did you recently apply Service Pack 3? If
so, this is a bug caused by that service pack and there is a hotfix that
you must now install.

 

[Doekoe]

Are you using Access 2003 and did you recently apply Service Pack 3?  If
so, this is a bug caused by that service pack and there is a hotfix that
you must now install.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Hi Rick,

Thanks for you reply, works fine.

Dirk