Re: Formatting phone numbers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 07:18:00 -0500

One reason for including the formatting in what you store is when you're
dealing with international applications. (nnn) nnn-nnnn is okay for North
America, but it isn't for other countries. 

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"Jim/Chris" <anonymous@discussions.microsoft.com> wrote in message
news:1376e01c3f72a$bae87730$a501280a@phx.gbl...
> Fredg,
>
> Thanks for all your help in this newsgroup.  I have learned
> quite a bit from you.
>
> In this case why would you want to store the ()- characters
> when a combination of the format and Input mask suffices?
> (I am referencing you update query) Or are these characters
> not really stored.  In all my forms and reports I use the
> format and Input mask.  In this case( a Mail Merge) I did
> have to put those characters in a temporary field for the
> word document merge.
>
> Jim

Relevant Pages

  • Re: Suggestion needed on data storage format in text file
    ... the mailbox file and store the summary in the text file for fast ... Then you run into the problem of someone who gets very verbose with their subject line and exceeds the 100 characters. ... Two other ways - use CSV format, which is well documented and supported by PHP and other programs. ...
    (comp.lang.php)
  • Re: Date Input and storage problem
    ... Date is to be input by user in dd.mm.yy format - ok using Input mask on ... input field on form but how do I code the VB behing my form to set up the ... >> up the field in the table to store it in this format? ...
    (microsoft.public.access.formscoding)
  • Re: Input mask question
    ... > an input mask is a way to help validate and modify the format of an entry. ... I want all characters to be capital letters. ... > "CMB from Omaha" wrote in message ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Date Field Masks
    ... whereas it will be stored in the database int the format dd/mm/yyyy - i ... I am trying to develop a database that will store dates in the format - ... The users won't know any difference when inputting ... as the input mask takes care of the placeholder. ...
    (comp.databases.ms-access)
  • Re: Stock exchange-related data
    ... We may assume that 20 characters is more than enough to ... bytes to store "Krung Thep Mahanakhon Amon Rattanakosin Mahinthara ... Fixed length strings are ... like Rexx' format rules ...
    (comp.os.os2.apps)