Simple piece of code but it won't work (1 Viewer)

[Geoff Codd]

I'm using A97 and I'm trying to do someting that I've done a hundred times before in A2k, but for some reason it won't work.

Any ideas would be a great help

Here's the code

Option Compare Database
Option Explicit

Private Sub Report_Open(Cancel As Integer)
If IsNull(Me.Standing_Charge_Per_Day) Then
Me.LblPer_Day.Visible = False
Else
Me.LblPer_Day.Visible = True
End If

End Sub

Thanks
Geoff

 

[Cosmos75]

Don't you need to have [] for fields that have spaces?

Me.[Standing_Charge_Per_Day]

Does Access97 even allow for spaces in Field names?

Edit: I am no good with Access VBA but I've read that somewhere.

 

[Rich]

You have to use either the on format or on print event