Lookup fields suddenly not visible

I have been using an Access 2002-3 accounting ledger database that I set up 3
years ago. It has always worked great, with pull down menus for Vendors,
accounts, sub accounts, etc. In the last month I have suddenly been unable to
see or use the pull down (Lookup) fields for Vendors. They are there, because
you can drag down a list, however, I cannot see the text until I have chosen
one, and I can no longer start typing names for it to jump to that name on
the list. Anyone else have this problem or have any clue as to why this might
suddenly happen? Is a security upgrade conflict? Something else?

Any and all help will be appreciated, because I have even tried to rebuild
from scratch and it will work right for a minute, then it will go away again.

Rich Uhrick

Not that I'll know the answer either way, but there is a big piece of
informaiton that you left out. Are you using the embedded-in-table-design
dropdowns or are you creating them yourself from tables?

Fred


"Rich Uhrick" wrote:

I have been using an Access 2002-3 accounting ledger database that I set up 3
years ago. It has always worked great, with pull down menus for Vendors,
accounts, sub accounts, etc. In the last month I have suddenly been unable to
see or use the pull down (Lookup) fields for Vendors. They are there, because
you can drag down a list, however, I cannot see the text until I have chosen
one, and I can no longer start typing names for it to jump to that name on
the list. Anyone else have this problem or have any clue as to why this might
suddenly happen? Is a security upgrade conflict? Something else?

Any and all help will be appreciated, because I have even tried to rebuild
from scratch and it will work right for a minute, then it will go away again.

Rich Uhrick

Well, I put them in the primary "Transactions" table to pull up info from
other tables. The really odd part is it only seems to affect the Vendors
table. (naturally the one that gets edited most often and has the most
information).

Rich

"Fred" wrote:

Not that I'll know the answer either way, but there is a big piece of
informaiton that you left out. Are you using the embedded-in-table-design
dropdowns or are you creating them yourself from tables?

Fred


"Rich Uhrick" wrote:

I have been using an Access 2002-3 accounting ledger database that I set up 3
years ago. It has always worked great, with pull down menus for Vendors,
accounts, sub accounts, etc. In the last month I have suddenly been unable to
see or use the pull down (Lookup) fields for Vendors. They are there, because
you can drag down a list, however, I cannot see the text until I have chosen
one, and I can no longer start typing names for it to jump to that name on
the list. Anyone else have this problem or have any clue as to why this might
suddenly happen? Is a security upgrade conflict? Something else?

Any and all help will be appreciated, because I have even tried to rebuild
from scratch and it will work right for a minute, then it will go away again.

Rich Uhrick

Rich,

I do 90% of my dropdowns the way you do them....in the table structure
itself. The experts say to not do it that way, that there are too many too
many problems / pitfalls with this method, and to use combo boxes etc. in
the forms to create dropdown functionality. That might be their answer on
your problem.

If your problem only shows up on a form, you might try deleting and
recreating the box.



"Rich Uhrick" wrote:

Well, I put them in the primary "Transactions" table to pull up info from
other tables. The really odd part is it only seems to affect the Vendors
table. (naturally the one that gets edited most often and has the most
information).

Rich

"Fred" wrote:

Not that I'll know the answer either way, but there is a big piece of
informaiton that you left out. Are you using the embedded-in-table-design
dropdowns or are you creating them yourself from tables?

Fred


"Rich Uhrick" wrote:

I have been using an Access 2002-3 accounting ledger database that I set up 3
years ago. It has always worked great, with pull down menus for Vendors,
accounts, sub accounts, etc. In the last month I have suddenly been unable to
see or use the pull down (Lookup) fields for Vendors. They are there, because
you can drag down a list, however, I cannot see the text until I have chosen
one, and I can no longer start typing names for it to jump to that name on
the list. Anyone else have this problem or have any clue as to why this might
suddenly happen? Is a security upgrade conflict? Something else?

Any and all help will be appreciated, because I have even tried to rebuild
from scratch and it will work right for a minute, then it will go away again.

Rich Uhrick

Did you by any chance recently install Office 2003 SP3?
It has caused some problems with combo boxes, but I don't remember exactly
what they were. If you did install SP3, you also need to install the hotfix
that fixes what SP3 broke.

The link is
http://support.microsoft.com/kb/945674

If this is not the problem, you may be having some corruption issues and
need to take care of those.

--
Dave Hargis, Microsoft Access MVP


"Rich Uhrick" wrote:

I have been using an Access 2002-3 accounting ledger database that I set up 3
years ago. It has always worked great, with pull down menus for Vendors,
accounts, sub accounts, etc. In the last month I have suddenly been unable to
see or use the pull down (Lookup) fields for Vendors. They are there, because
you can drag down a list, however, I cannot see the text until I have chosen
one, and I can no longer start typing names for it to jump to that name on
the list. Anyone else have this problem or have any clue as to why this might
suddenly happen? Is a security upgrade conflict? Something else?

Any and all help will be appreciated, because I have even tried to rebuild
from scratch and it will work right for a minute, then it will go away again.

Rich Uhrick