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!!!

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.