How do I get list box data to display properly in a report?

G

Guest

I'm using Access 2003.
My database has several fields set up as list boxes with a value list and
specified items. I've done a query including these fields and set up a
report on the query. When I print the report, the fields in question come up
as white on black. If some of the fields are empty, the first value from my
list prints out. In some cases, a field that has been entered doesn't show
as what I entered, but as the first value in the list.
I'm open to all advice.
 
D

Duane Hookom

I'm glad to hear you are "open to all advice"... Don't use lookup fields in
tables ;-) http://www.mvps.org/access/lookupfields.htm

It is very rare that a list box would be used on a report. Values entered
from list boxes on forms are normally displayed in text boxes. If you don't
want to use a text box, try change the list box to a combo box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top