Results 1 to 4 of 4
  1. #1
    aaghd is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    2

    Invisible LookUp Data List

    I have created a simple table, two fields, an Autonumber Primary Key, Field Name - lngBureauID and a Text Field, strBureauName. In a few other tables I have called this table data using the LookUp Data Type. No big deal! However, when I drop down the list of Bureaus the Bureau Name is invisible. If you select something from the list the data is then visible in the table however you don't ever know wht you are selecting because you can't see it. When I make the Primary Key visible, it is visible but the text string field is not. What would cause a fields data to be invisible? I hope you can help me because I can't ask users to select data from a list when they can't see the data. I have looked everywhere for a format or system property that may be causing this issue, I am stumped. I have even created the table again, and ended up with the same problem. I have even created a new database and table and ended up with the same problem.

    Thanks for the assistance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Have you applied all of the Office 2003 updates and HotFixes? Do you have something in the Format property for that field in the table? If so, them remove it.

  3. #3
    aaghd is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    2
    Thanks for the response. No, I don't have any formatting set anywhere that would perclude it from displaying the strField.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Have you applied this HotFix?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Empty Lookup
    By mikel in forum Access
    Replies: 39
    Last Post: 08-07-2009, 01:00 PM
  2. List box to populate other list boxes
    By Nathan in forum Forms
    Replies: 0
    Last Post: 03-03-2009, 07:22 PM
  3. Lookup
    By neon'00 in forum Forms
    Replies: 2
    Last Post: 04-14-2007, 01:19 PM
  4. Lookup Tables
    By JoeBio in forum Database Design
    Replies: 1
    Last Post: 09-01-2006, 07:34 AM
  5. Lookup or list field: how Do I not show all records
    By scott munkirs in forum Forms
    Replies: 4
    Last Post: 04-13-2006, 12:44 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums