Twitter
LinkedIn
YouTube
RSS
Facebook

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:

1

<< 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 http://vbahowto.com/ms-access-tutorial

Helpful? Consider giving us a tip. Thanks!

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




Want All The Access Videos?, Click Here!

Learn to program



Need help? Click and Call LoeblCom Services



Leave a Reply

You must be logged in to post a comment.