Blank spaces in the Report

[coryras]

In the detail portion of the report I have a code field that I want to display on certain information. I have an iif statement setup to display the ones that I want showing but in the else portion I don't have doing anything so it just leave a blank spot on the report like this.

Marker 1000
Services 200
****blank space
Casket 1000

I need the amount of all the fields so I can't just disregard the codes in the query. How can I get this blank line to not display on the report?

 

[CosmoKramer]

Where is your IIf statement??

 

[coryras]

My IIF statement is in the detail portion of the report. It is in a Text box for the code.

Its like this IIF([tbldetail.code] not like "other*" and [tbldetail.code] not like "cash advance*", [tbldetail.code])

 

[CosmoKramer]

Try code like this in the OnFormat event of the detail section, changing for your text box name:

If IsNull([YourTextField]) Then
   Cancel = True
End If

This should cancel the printing of the detail line if it is null.....