I have a report that reads a a checklist of info. I am using an IIF statement to determine whether or not to show field on my report. I only know how to get the field not to display (the negative of the IIF displays as""). I want to find out how to avoid holding a place, and having the report read the rows in consecutive order. THe Report sort of looks like this like this now.

RESULTS
Did not complete 1
Did not complete 2

Did not complate 4

Did not complete 6

I want it to display like this

RESULTS
Did not complete 1
Did not complete 2
Did not complate 4
Did not complete 6

I dont want to hold a space for that is blank. How do I control the field so that IIF returns it as empty so the Can Shirk control can kick in. Can I control the CanShrink in the IIF? I am not a very experienced developer. As you can tell. Any help would be appreciated.