Report format problem (1 Viewer)

[arage]

The following code is meant to format the appearance of report data if a certain field is 0 or null, but I get run time error 2448 that I cannot assign a value to the objects.

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.TotalPays) Or Me.TotalPays = 0 Then
Me.DateSentToAccounting = ""
Me.Cheque_ = ""
Me.DateMailed = ""
End If
End Sub

 

[KevinM]

If the fields are bound then you won't be able to change their values in the report like you can in a form.

Try putting your expressions in a query first and then base the report on this query. That way you will be able to include these calculated expressions on the report rather than the fields themselves.

hth