Where is my data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dwight - 06 Dec 2007 18:44 GMT

I have a listbox on a form that is not showing the data anymore.

It seems to be associated with a particular table. I can create new
listboxes on the form using a different table and it works fine. I try to
create a listbox on a different form using the table in question and the
results do not show. I do not see anything wrong with the table. All the
data is still there.

We got new computers which upgraded our Office product from MS Office 2002
to MS Office 2003.

Any ideas what the problem is and how it can fix this?

Thanks in advance

Dwight

Reply to this Message

Linq Adams - 06 Dec 2007 18:59 GMT

Unfortunately, you've apparently to the SP3 service pack and it's buggier
than the Great Dismal Swamp! One of the most common bug reported involves
comboboxes/listboxes with disappearing data! The field(s) in the cbo/listbox,
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. The only other option is to un-install Access then
re-install up to SP2.

Here's a link to Allen Browne's site where you can find the latest news about
these bugs:

http://allenbrowne.com/tips.html

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message