In this part of the video series you’ll learn the following:
Working With VBA Variables
Obtaining Values From The User
How to use the VBA Inputbox
Efficient Variables In Your Application With The Dim statement.
Before you do the quiz, here are a few points to realize:
Input Masks set a format structure of the way data should be entered.
You need to check out this handy table on input masks. Click here.
The Trim function
If you need to get rid of spaces at the beginning or end of your text, the Trim function is going to be your friend.
To remove a space and the beginning of a piece of text, use LTrim
example: LTrim(” Erik”) = “Erik”
To remove a space and the endof a piece of text, use RTrim
example: RTrim(“Erik “) = “Erik”
To remove a space and the beginning and end (or either/or) of a piece of text, use Trim
example: LTrim(” Erik “) = “Erik”
You can setup some validation text on a table, and it will display in the form of a message box. Again, you should click here to check out my other post on validation text.
You can use an Input Mask, Validation Rule, and Default Value to regulate the integrity of your data. Making a field “Required”, needs to be done at the table level, to have the database control this, or you could add VBA code to make a field entry a requirement.