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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top