Run Time Error 94

[Vethra]

Hi everyone,

I'm sure this is simple for all of you guys but unfortunately I can't find a solution. Everything works great except one thing, run time error 94 "Invalid use of Null" when textbox value is deleted and the check box is still checked.

Private Sub Textbox1_Afterupdate()Checkbox1.Tag = Textbox1.Value
End Sub

Thank you,
Dilan

[pbaldy]

Shot in the dark, but try wrapping the textbox reference in the Nz() function.

[Missinglinq]

Dead on shot, Paul...you must be using Night Vision Goggles! If the data in Textbox1 has been deleted, Dilan, the Control's Value is Null, and you cannot assign Null to a Tag Property as you're trying to do with

Checkbox1.Tag = Textbox1.Value

causing the Access Gnomes to complain with Error 94.

Private Sub Textbox1_AfterUpdate()
 Checkbox1.Tag = Nz(Me.Textbox1, "")
End Sub

assigns a Zero-Length String to Checkbox1.Tag if Textbox1 is empty, i.e. Null. You could replace the ZLS ("") with some other, appropriate String, if you wanted to.

Linq ;0)>

[Vethra]

Thanks Pbaldy that works perfect!

[pbaldy]

Happy to help!