Validating form field
He is certified in Visual Basic 5.0 and Windows Architecture (1 and 2).
You may want to prevent users from saving Microsoft Access records with missing information, especially if this data is important.
You will need to put your validating code in the Microsoft Access form's Before Update event. " Style = vb Critical vb OKOnly Title = "Required Data..." Msg Box msg, Style, Title ctl.
In the United States, there are a number of valid formats for phone numbers that might be entered into a form: There are many other variations of this, as well, but those examples should be enough to give you an idea of what we're dealing with here.Here's what you need to do :- Switch to design view from markup view . From the toolbox that opens click on Validation and drag a compare validator near your textbox.Right click on the compare validator and choose properties , now locate Error Message and write "Alert : Type only Number" . In the Operator choose Data Type Check and in the Type choose Integer. The computer is now smart enough to automatically translate data into the format that has been pre-selected for use in that system, saving timeand no doubtmoney.Eric Smith has been a senior consultant with Andersen Consulting, specializing in client/server development using Oracle and Visual Basic, and was senior content developer (Visual Basic) at before it was purchased by Fawcette Technical Publications.