Displaying controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help I'm going round in circles!

I have a check box on a form and depending on whether it is ticked or not I
want to display one of 2 controls on my report - but I cannot seem to get the
right "test" - Access keeps telling me "Invalid use of null".

This is my code (whichi is attached to the On format of the detail section
of the report:

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

If Forms!exhibitorfrm![Casual] = 0 Then
Casualto.Visible = True
Formalto.Visible = False
Else
Casualto.Visible = False
Formalto.Visible = True
End If

End Sub

I have also tried using "Yes" and "True" and is null. At one point I had it
so that it always displayed one of the controls (not what I was wanting) but
I can't even get that now!!
 
OK I've answered my own question - I think I must have used "true" instead of
true!

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

If Forms!exhibitorfrm![Casual] = True Then
Casualto.Visible = True
Formalto.Visible = False
Else
Casualto.Visible = False
Formalto.Visible = True
End If

End Sub
 
Back
Top