Listbox in Reports

[Samantha]

I have a listbox in a report, but I can't seem to make the length of the
listbox to shrink when there are less items or no items in the list. The
listbox is bound to the ID field of the datasource for the report.
Is there other properties of the listbox that I'm not seeing? thank you in
advance.

 

[Douglas J. Steele]

Sorry, but I don't see the point of having a listbox on a report.

Listboxes are intended to be an interactive control, and reports aren't
interactive.

I think you'd be better off trying to use a subreport.

 

[PC Datasheet]

Experiment with the ListCount and Height properties of the listbox.
Determine experimentally how many inches it takes per record in the listbox
and then use ListCount to count the records and set the Height accordingly.