List Box - Shows all items in list box & highlighted

[Sharon Hague]

Hi All

I have designed a report from a query which comprises of various fields whish are list box fields.

When I preview the report the list box fields are constantly highlighted in black - (which is due to that item being selected). Also unless you shrink the height of this field in the reports design view it shows all items in the list box.

How can I stop this?

 

[Rich]

There is no point in using a list box on a report, change it to a textbox

 

[Sharon Hague]

How do I change it to a text box when it automatically recognizes this as a list box from the table/query?

I can't find anywhere in its properties to do this.

 

[IMO]

In design mode, right click the control and go to 'Change to'.

IMO

 

[Rich]

Right click on the box in design view, change to textbox, there is no point in having a list box defined in a table either

 

[Sharon Hague]

Thanks IMO

Problem solved - That's twice today you've helped me out.

Cheers.

 

[IMO]

You're welcome

IMO

 

[Rich]