A problem with list boxes

D

Don

I'm using Access 2003 and I've installed SP3 within the last couple of weeks.
I've opened an Access database that I've been using for at least 3 or 4
years and have found every list box that I've previously set up are showing
no records except for the bound column. I haven't edited this database and
no one else uses it. I created a new blank form and rebuilt one of the blank
list boxes and it also shows no records except in the bound column.

Could the new service pack have caused this problem? I'm at a loss because
I have 9 or 10 databases that I use and this is the only database that this
has happened to.

Thank you for any help you can give me.
 
J

Jeff Boyce

Don

Congratulations!

What you've documented for listboxes has already been documented for
comboboxes (i.e., contents disappear) as an "unintended consequence" of
installing SP3 for Office 2003.

I hadn't seen the same showing up for listboxes, though.

The solution (i.e., "work-around") for the comboboxes is to go back to the
underlying table(s) and remove any Format properties.

No guarantees this will also work for emptied listboxes. Please post back
if it DOES, so others can find a work-around when they run into this.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KARL DEWEY

Open the form in design view, click on menu VIEW - Properties. Click on the
list box check what the Row Source reads. If it is a query then run that
query to see if it is the problem. If a select statement then copy and paste
it in a query to check.
Chech the column count and column widths.
 
Top