Closing gaps in a form or report.

[SonyaEnz]

I have a form where a User can select more than one item (checkbox). If a user selects items 1, 2, 4, 7 and 10 and runs the end form/report there is a gap between the selections. Such as it would show:



Cat
Dog

Bird


Alligator


Ostrich

How do I close the gaps so it would be a solid list?:

Cat
Dog
Bird
Alligator
Ostrich

I was thinking as a subform or subreport but that still had gaps.

Thanks.

Sonya

[ranman256]

If the query is doing an outer join, you will get gaps for the missing items, so...
put NOT NULL in the column where items can be missing. The gaps will close.

[SonyaEnz]

In this instance there is only one table (its a simple document) that I am using and for the main form I use a query but for the final report/form, I use a query with IIf statements. I have tried the Not Null but when I do, no information (even the information needed) will show on the final form/report.

[SonyaEnz]

Unfortunately, not been able to get this one resolved for the time being. Luckily, I can put the most common requested items first and deal with the other items later. For now I will just mark this one as solved.