Hi Everyone

I want an unbound textbox named txtCancelled to display "Cancelled Member"
If the Control MembershipCancelled contains a Date

I tried using this in the On Load of the Form

Private Sub Form_Load()
If Me.MembershipCancelled = Null Then
Me.txtCancelled.Visible = False
Else
Me.txtCancelled.Visible = True
End If
End Sub

I also tried = ""

When I navigate to any record the Cancelled control stays visible at all times

Where should I place this Event???

Your help appreciated

If you're relying on the contents of a field/control for a record to which the form is bound, try using the OnCurrent event.

The reason it doesn't change is because your code is in the Form_Load event which rns when the form is loaded. To make it run each time you navigate to a new record, put it in the Form_Current event.

Mike

And to reduce the code to one line:

Me.txtCancelled.Visible = Not (Me.MembershipCancelled = Null)

Hi Bruce

Tried this one liner:-

Private Sub Form_Current()
Me.txtCancelled.Visible = Not (Me.MembershipCancelled = Null)
End Sub

Gives me Runtime Error 94 - Invalid use of Null

Any suggestions??

Hi Bruce

Also tried this

If Me.MembershipCancelled Is Not Null Then
Me.txtCancelled.Visible = True
Else
Me.txtCancelled.Visible = False
End If

Gives Runtime error 424 - Object required ??

Hi Mike,

What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.

If this is a calculated field, I recommend you don't store the value in the table. To just display something like that on the form, you can use an Unbound textbox with the following Control Source:

=IIf(IsDate([MembershipCancelled]),"Cancelled Member","Active Member")

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

That won't work because technically Null is not a value that can be tested, but rather it is a non-value.

Try:



Alternatively, I often use:



Mike

Hi theDBGuy

A2010

When I used your String in an Unbound Textbox then I get this error #Name?

Thoughts??

Hi Mike

This works

Me.txtCancelled.Visible = Not IsNull(Me.MembershipCancelled)

Many thanks everyone for your help

Make sure you use the name of the control. Please remember what I said about storing calculated fields in your table.

Good luck!

Sorry about that = Null thing. I know better. I must have reverted early to my weekend brain. (IMG:style_emoticons/default/blush.gif)