I am trying to design a report for database in which I have used list boxes for some of the fields.

Instead of printing just the value that was selected from the list box, the report prints out the entire list of available values, and blacks out the one item that was selected.

This is not an especially helpful way to display data.

Can anyone tell me what I am doing wrong? Is more likely to be a problem with the way I set up the report, or the way I set up the list?

A listbox is a control that is useful for selecting one or more items from a list. It is intended to be used on a form. Since you cannot select anything from the listbox if it appears on a report, normally people will use a text box instead for the report unless for some reason they want to see all the options in addition to the selected one..

Thanks, but I'm still confused.

I used the listbox on the form I set up for the data entry.

I then entered some sample records.

Then I opened a new report and used a wizard to set it up. I just wanted the values entered to each of the fields dumped into the report.

Would the wizard have set up a list box instead of a textbox on the report? I'll go check that, but it seems like an odd thing.

The data should be drawn from the table, not from the form, right?

You must have specified listbox as the display format in the table description. You can easily change it though for the report. One thing though, you'll probably need to base the report on a query rather than the table so you can obtain the "text" value for the field in question.

Ah. That makes more sense. I'll try that. Thank you for your advice!