OK Bill and Duane. I am convince I need to remove my formatting in the
table. I will do that. So the form that I use to view and input the phone
numbers will have a format the actual table will not and if I view the phone
number in the table it will look like 1234567890 but the form will show
123-456-7890. Am I understanding that correctly? That sounds fine to me.
The problem I have is how do I get the 700+ phone numbers changed. Do I
have to retype all of them. Duane. What is this code to update all the
current phone numbers in the database? Will it go through the phone
numbers and remove the dashes?
Bill Singer
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Sunday, September 16, 2012 9:02 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Phone number formatting
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
<mailto:MS_Access_Professionals%40yahoogroups.com>
> From: wrmosca@comcast.net <mailto:wrmosca%40comcast.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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of agent1of6
> Sent: Sunday, September 16, 2012 3:12 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar