Bill
The first rule is to not store phone number (or any other data) in a specific
format. They should be stored as text. Then apply the formatting to the forms
that display the data.
Capeesh?
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of agent1of6
Sent: Sunday, September 16, 2012 3:12 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Phone number formating
I am putting together a form that will look up clients based on a few items. One
of the items is Home Phone number. I created a combo box that searches the table
t_Clients.
In the table I have the input mask as phone number.
the problem is that I am getting phone numbers showing up in the combo box with
the dashes in different places. I am getting these formats...
123-456-7890
123456-7890
123-4567890
Any idea what I have to do to get all the phone numbers in the combo box to show
up the same way. The search function of the combo box uses the dash as part of
its sorting and could cause the end user to miss the number if the dash is put,
or not put in.
Thanks,
Bill
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar