MS ACCESS report . Do not display field if certain condition not met.

[mmccarthy]

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.

[RobDog888]

Where is your IIF code?

In the code behind the report you can add the "Private Sub
Detail_Format(Cancel As Integer, FormatCount As Integer)"
procedure. Then code the IIf and if the negative condition occurs
then you Cancel = True.

This will prevent the report from formatting the line where the
condition is negative and the blank line will be suppressed.

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

HTH