I agree with Bill (Mosca). If this was my application, I would create a small function to update all the phone numbers to store the numbers with the correct formatting.
Then get rid of all input masks and ensure the appropriate format with code or other method.
Duane Hookom
MS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: wrmosca@comcast.net
> Date: Sun, 16 Sep 2012 18:52:05 -0700
> Subject: RE: [MS_AccessPros] Phone number formatting
>
> 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]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar