Print Listbox COntent

[RainX]

ello again,

How would one go about printing just the contents from a listbox (called listData) on a form using a command button?

Thanks in advance

Tc

 

[ansentry]

Do you mean;

"I have a list box on a form and I would like to print it contents"

if so, create a report and base it on the source of your list box. Put code to open the report (you could use the wizard) behind a command button use the onClick event.

 

[cuttsy]

Is there a way of doing this without crating a report?

 

[boblarson]

Is there a way of doing this without crating a report?

yes, there is but how do you want it displayed? In a message box? If so, there is a limit to what it can display. I guess we're not sure what you're trying to accomplish. More info would be good.

 

[cuttsy]

Yes, sorry about being vague.

I have some combo boxes that are used to build an sql string which is used to populate a list box.

I was hoping I would be able to somehow use this same sql string to print the contents of the list box.

Or even create a querydef and print that.

I was hoping to achieve a result similar to when you open a query and click the print button.
I was also hoping to avoid opening a query and requiring the user to press print.
I may have to do this to get the results I require.