Results 1 to 2 of 2
  1. #1
    tigers is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2006
    Posts
    28

    List Box in Form is causing black boxes to print on a report

    We created a table and then created a form to add records to the table. One of the fields in the table, we changed to a Listbox via the lookup tab. So, we then added this field from the table into the form.

    There are three options. If you want the option in the listbox to populate the table, it has to be selected on (and we know this because the selection is black). The options are ""; "yes"; "no".

    So, we dropped in the field that uses the listbox into the report and there are black boxes for this field displayed on the report. If we selected the "" option, there is a black box. Where we have made a "yes" or "no" selection, it is showing a white font inside of a black box. We don't want this black box showing on the report. We tried to format the field on the report (rightclick-properties) but it is not making a difference at all. You can tell that the background is changed but the black box is still showing inside of it.

    Has anyone ever ran into this before and do you know how to fix it??



    Thanks!!!

  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,922
    I would not use anything but a TextBox as a Lookup for a field. Your choice.

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

Similar Threads

  1. 2 multi select list boxes on one search form
    By woodey2002 in forum Forms
    Replies: 2
    Last Post: 11-05-2010, 12:44 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. Replies: 1
    Last Post: 03-01-2009, 09:53 AM
  4. Replies: 0
    Last Post: 02-26-2009, 03:34 PM
  5. Replies: 3
    Last Post: 03-24-2006, 08:40 AM

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