Report from Query

[chaddresnick]

I created a report from a Query and the report has scroll bars on it under "Make". In the original table, I have a list of three makes of vehicles (Dodge, Ford and Chevy). Why would the scroll bars show on the report? How can I just show the value that was selected on the report?

[pbaldy]

Is the control on the report a listbox? It should just be a textbox.

[chaddresnick]

it looks like just a text box.

[pbaldy]

Make sure the scroll bars property is set to none then.

[chaddresnick]

No scroll bar option except the one shown.

[pbaldy]

The column properties imply it's a combo or listbox. Can you post the db here?

[chaddresnick]

Fixed. Thank you.

[pbaldy]

No problemo.