Hide Detail if field is Null

[MochaLatte]

I need to hide detail section (eliminate space) if specific field is null.

 

[dhookom]

Is there a reason why you don't filter the Record Source query?

Duane
Hook'D on Access
MS Access MVP

 

[MochaLatte]

Hi Duane! Thanks for your suggestion. Filtering the query is not an option. There are other fields on those specific record that need to be displayed on other sections (groups)of the report.

 

[dhookom]

Add code to the On Format event that cancels the formatting of the field is null.

Duane
Hook'D on Access
MS Access MVP

 

[MochaLatte]

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Cancel = (IsNull(Me.TxtDetail))

Is this code Incorrect? Something is not working

 

[dhookom]

Is txtDetail the "specific field"?

You can't just state "Something is not working" without providing some description of what is or isn't happening that should or shouldn't be happening.

Duane
Hook'D on Access
MS Access MVP