onformat for report make visible/invisible

[ChrisB37]

I want my fields on the report to show up if there is data to show and to disappear if no data is avaliable. Also, will the fields format together or will they still stay apart? I need them closer together for the report.

Here we go.

In the report are months 1, 2 and 3 as well as the label box for each. I need the label box and the data(text box) to disappear when the data box is null. This is where I had started:

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

If Not IsNull(Me.Ctl1_Month) Then Me.Ctl1_Month.Visible = True
Else
Me.Ctl1_Month.Visible = False
End If


End Sub

But when I try and run the report I get this error:
Can't Execute Code in Design Mode.

Can someone help as to what I have done wrong or where I should place this type of format?

Many thanks.

 

[WayneRyan]

Chris,

Forget the code and look into Conditional Formatting.

See Access Help or use the Search Facility here.

Wayne