Make Report Label Visible (or not)

[libraccess]

Private Sub Report_Load()
If Me.status = Active Then


Me.lblDateRes.Visible = False
Else
Me.lblDateRes.Visible = True
End If
End Sub

I thought this would work - any help please

[ItsMe]

What type of control is status?

[libraccess]

that was quick

Text field size 20 could be either Active or Resolved No Edits

[ItsMe]

So maybe you need some quotes to determine the literal text.

If Me.status = "Active" Then

[libraccess]

Doh

I had them in there in my first write of that but somehow they fell off
funny how when I start to look hard at something I miss the obvious

[ItsMe]

That's how it is sometimes. Glad it was something simple though.