ListBox Troubles

[reb0101]

Hey all,

I’m about to pull my hair out here trying to figure something out.
Hopefully someone out there can help me out on this one.
I’m finishing up a database and I have a form with several fields on it.
There’s quite a few records so I want to be able to have the users be able to select a record with a ListBox to view the fields and edit if need be.
I used the wizard and put a ListBox on the form. I set it to find a record

I then selected “Find a Record on my Form based on the value I selected in my listbox”.
So far so good.
Then when I ran it the ListBox is there but the records (in this case items) are no visible.
All I have is an empty white box.
The records however are there, you just cannot see them.
If you click into this blank white space it will select a record. You will then see a thick black line across the ListBox which is where the selected record background turns to black and the record name then changes to white to highlight the record you selected.

The record also displays the additional fields in the form.
So it does work, just can’t see what you are clicking on.
I have tried changing the background color of the listbox and the font color and that doesn’t do anything but change the background color of the whole listbox.

Does anyone have any ideas what is going on here?

 

[boblarson]

Just a shot in the dark, but do you happen to have Access 2003 Service Pack 3 installed?

 

[reb0101]

I'm not sure about the service pack but I don't think it will matter.
Rason being is it works in another DB I have on same machine, even same folder

 

[KenHigg]

Sounds like a video memory issue. Have you tried re-booting the machine?

 

[maxmangion]

Hi,

you could try creating a new database on the same pc which is giving you the problem, and import all your objects to the newly created database, maybe you have some corruption in this particular database.

 

[KenHigg]

Hi,

you could try creating a new database on the same pc which is giving you the problem, and import all your objects to the newly created database, maybe you have some corruption in this particular database.

Or try the problem .mdb on another box - ?

 

[JoseL]

Having the same problem and after searching this forum I found how to fix it.
You can go to the table design and leave blank the formatting property of the affected fields.

Hope this will fix your problem also and thanks a lot to that people who posted how to resolve it (so sorry, I don't remember now who were them).

 

[LPurvis]

So it was an SP3 issue.
Try to put your faith in what's being suggested. ;-)

(FWIW I do feel that also removing the formatting condition is very appropriate - in conjunction with the SP3 hotfix).

 

[missinglinq]

I'm not sure about the service pack but I don't think it will matter.
Rason being is it works in another DB I have on same machine, even same folder

As LPurvis said, it was a SP3 service pack issue! The other DB that worked simply didn't have formatting in the fields that populated the listbox. Removing the formatting is a quick fix, but this service pack had a bunch of bugs, and you really do need to apply the hotfix.

Here’s a link to Allen Browne’s article on these bugs. There’s a link at the end of it to the hotfix for SP3.

http://allenbrowne.com/bug-Access2003SP3.html