[MS_AccessPros] Canel = True and Exit Sub statements

 

 

Hello Good morning

The Sub procedure that I have here included the "Cancel = True" and an "Exit Sub" statements.  I am wondering if the "Cancel = True" and the "Exit Sub" are always necessary there and/or when they can be omitted.

Phucon

Private Sub txtEmployeeID_BeforeUpdate(Cancel As Integer)

If Len(Me.txtEmployeeID) > TempVars!tvMaxlen Or Len(Me.txtEmployeeID) < TempVars! tvMaxlen Then

     MsgBox "Employee ID must be " & TempVars!tvMaxlen & " characters in length.", vbExclamation, " "

     Cancel = True

End If

Exit Sub

End Sub

__._,_.___

---

Posted by: saigonf7q5@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___