Ms access runtime error 5 string9/25/2023 ![]() If Len(Me.txtProg & vbNullString) = 0 Then Exit Sub If IsNull(Me.txtProg) Or Me.txtProg = vbNullString Then Exit Sub Therefore, your code probably wants to check for Null and zero-length string before taking any other action. ![]() Possibility that its value is a zero-length string that is, "". For a text box, if the control is bound to a text field, or is unbound, you may also have to allow for the So your AfterUpdate code has to allow for the possibility that the control is Null. As far as Access isĬoncerned, you modified that control to set its value to Null. The first thing to realize is that, if you enter something in the text box (or combo box) and then delete that entry, the control's AfterUpdate event is still going to fire, even if you completely deleted the contents of the control. Is it a text box, or a combo box as you first said? That really doesn't matter to the error, but it's good to be precise about these things.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |