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>>

Get all the videos in this Access VBA collection 100% FREE by signing up at

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Click Here And Visit Our Store!

Helpful? Consider giving us a tip. Thanks!

($5 suggested amount)
(...10% of your gift amount will go to charity)

Need help? Click and Call LoeblCom Services

Leave a Reply

You must be logged in to post a comment.