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?

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....
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Mercadogs" wrote:

> 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?

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. 

"Jerry Whittle" wrote:

> 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....
> -- 
> Jerry Whittle, Microsoft Access MVP 
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> 
> "Mercadogs" wrote:
> 
> > 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?