MS ACCESS FORM VALIDATION – PT4

In this video we will cover VBA validation functions like:

Validating Text Strings
Check the string for null values.
IsNull function

Check the length of a string.
Len Function

Check the presence of characters present in a string.
InStr function

Inpect a portion of a string.
Left, Right, Mid functions

Removing the leading or trailing spaces, or both, from a string of text.
Trim, LTrim, RTrim functions

Validating Numbers
IsNumeric function
IsDate function

Here is the video:

<< MS Access Validation – PT2 (explained) | How To Make A VBA Function>>


Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags: , , , , , , , , , , ,




 

Call Erik Now