Print values of a listbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mercadogs - 31 Dec 2007 19:47 GMT

Is there a way to make a report that prints the values of a form's listbox.

I tried making a report in design view to accomplish this. I inserted a
listbox in the report and made it bound to the form's listbox, but the report
only prints a limited amount of items on the list (those which are visible in
the listbox).

Is there a way to have the report print all the values of the form's listbox?

Reply to this Message

Jerry Whittle - 31 Dec 2007 19:56 GMT

How is the list box populated? If it's based on a table or query, make a
report based on that table or query.

If the Row Source Type is a Value List, I don't know....

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Is there a way to make a report that prints the values of a form's listbox.
>
[quoted text clipped - 4 lines]
>
> Is there a way to have the report print all the values of the form's listbox?

Reply to this Message

Mercadogs - 31 Dec 2007 20:12 GMT

Hi Jerry:

Thanks for your response.

The list is populated from a query called "Sp" that is filtered by entering...

SELECT DISTINCT Sp.PartNum, Sp.Loc FROM Sp ORDER BY [PartNum];

.... in the rowsource property of the listbox.

I had to manipulate this property because otherwise I could not make a new
query that would allow me to set property of the new query to 'unique values'
in order to get distinct combinations of 'PartNum' and 'Loc' fields of the
query 'Sp'. For some reason queries that have the "Group By" commands give
this problem.

> How is the list box populated? If it's based on a table or query, make a
> report based on that table or query.
[quoted text clipped - 9 lines]
> >
> > Is there a way to have the report print all the values of the form's listbox?

Reply to this Message