Phone numbers

[Guest]

In a form, as a customer enters their phone #, how do you make it auto-format
with dashes? Also, upon entering dates and times, I need it to be customer
friendly meaning the use of colons or specific front slashes etc. are not
needed to be used by the customer. Just enter the numbers for the date and
it automatically knows how to save them. For time, just enter the number. I
have an Am,Pm option.
Thanks

 

[Rick Brandt]

In a form, as a customer enters their phone #, how do you make it
auto-format with dashes? Also, upon entering dates and times, I need
it to be customer friendly meaning the use of colons or specific
front slashes etc. are not needed to be used by the customer. Just
enter the numbers for the date and it automatically knows how to save
them. For time, just enter the number. I have an Am,Pm option.
Thanks

In design view of your form click on one of the TextBoxes and then brign up the
property sheet. On the { Data } tab put the cursor in the InputMask and then
press <F1> to bring up the help topic.

 

[Al Campagna]

TRS,
For phone numbers, use the InputMask property. If you place your cursor in the
InputMask property field, and hit the little 3dot (...) button on the right, a wizard will
assist you in setting that up, or just use the pre-defined PhoneNumber mask.
For Dates and Times, you would also use InputMasks for say ShortDate or ShortTime
(there are several types)
Be aware though that even Dates with an Input mask like ShortDate require 6 digits.
010107 = 01/01/07
MediumTime Mask requires 4 digits and an A or P to signify AM or PM.
01:23
ShortTime Mask only requires 4 digits, but users must enter "military" time
1530 = 15:30 (represents 3:30PM)
0900 = 9:00 (represents 9:00 AM)
--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."