I have a List Box in my DB which is like a scroll down list. The user can click the down arrow and click and choose the type he wants. It works well in data entry, edit, search etc. But when I made a report, it displays all the choices in the list whereas I only wanted it to show what the user has selected. What could be the problem? Grateful for help.

you should not show a listbox in a report. instead change it to a txtbox by right clicking>change to then select txtbox.

This will solve your problem!!

I would suggest you replace the list box or combo box control you have in the report and replace it with a regular text box control that is bound to the appropriate field...:)

Thank you very much for the help. I will do it.

Looks like 'rain' beat me to the punch on this one :)