Results 1 to 2 of 2

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

  1. #1
    Join Date
    Mar 2006
    Posts
    29

    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
    Join Date
    Jan 2009
    Location
    Portland, Oregon
    Posts
    21
    1. Get rid of the lookup at table level. They are BAD and cause all sorts of problems ( see here for more about that).

    2. Once you've gotten rid of the lookup at table level, I think you may find that things work a whole lot better. Be sure to change your control on your report from a listbox to a text box.
    Bob Larson
    Former Access MVP
    2008-2010

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •