• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2120
  • Last Modified:

Microsoft Access - drop down menu's empty

I am using MS Office with Access 2003 and the drop down menu's look blank, but I can actually scroll down each field and choose an entry, but it's a mystery which one I'm on.

Not sure if it's related, but It happened around the time I installed a new Antivirus, but I've since uninstalled and it continues.

Can anyone help?
0
Ryman1
Asked:
Ryman1
  • 3
  • 3
  • 2
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
uninstall office using Control panel> add remove program
reinstall office up to sp2
0
 
puppydogbuddyCommented:
Look at the code in your form module, and make sure you are not  setting any of the fields in your droplist to visible = False. Also look at the visible property of those controls on their property sheet. Also check the background and foreground color properties of the dropbox  and controls therein.  
0
 
Ryman1Author Commented:
Thank you for these.

It's at SP3

Also, it's a shared Access DB and everyone else in the office can see the drop down items. It's just this one computer. Other ideas?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Rey Obrero (Capricorn1)Commented:
get the hot fix for SP3
http://support.microsoft.com/kb/945674

if that does not fix the problem do as i said about unistalling office
0
 
Ryman1Author Commented:
The hotfix totally worked. I love you!
0
 
puppydogbuddyCommented:
Make sure the one machine is running off the network copy of the application, and is not running from a local copy of the application  on his/her PC.

Also, look at the settings for the columns and column width properties for the dropdown box.
The number of columns visible in the combo box dropdown list is controlled by a combination of:
                the .Columns property of the combo box
                the width property for each column.
Columns with a width value of zero, are present and available in code, but are not visible to the user.

0
 
puppydogbuddyCommented:
oops! did not refresh in time.  Good solution Cap!
0
 
Ryman1Author Commented:
Worked Perfectly!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now