Don’t leave it to the auto-generated default messages.
Explain to your user what is wrong and suggest solutions.
And, what should be Datasource Update Mode- On Property Changed or On Validation?
Doing so can cause your application or the operating system to stop responding.
Therefore, despite the fact that it doesn't cover all possible formats of phone number in the world, you can use the regexp validator to test a phone number in your country.
'Then in the Before Update Event of the form, copy/paste the following: Dim msg As String, Style As Integer, Title As String Dim nl As String, ctl As Control nl = vb New Line & vb New Line For Each ctl In Me. When we enter information into the form, any fields that are tagged and left empty, will cause the following error message to be generated, and will not allow updating of the record: The above shows the record trying to be saved when the 'Birth Date' field has been left empty, and has been set to not allow missing information.
Form Validation provides the built-in phone validator to validate the phone number in various countries.