selecting listbox items

[JML via AccessMonster.com]

I have a listbox that when selecting item/items, it prints it on a report,
unselected items won't be printed but it would leave space.

For ex.

item 1 - selected
item 2 - selected
item 3 - not selected
item 4 - not selected
item 5 - selected

so in print report, it should print the selected ones, and leave the not
selected a blank space

item 1
item 2
<blank>
<blank>
item 5

I understand that you can filter the selection in a listbox but It would
print only as w/o the blank space.

item 1
item 2
item 5

I want to leave spaces for the unselected items. How should I do it?

 

[KARL DEWEY]

Try using IIF statement with a space as output -- IIF([YourItem] Is Null, "
", [YourItem])