You're doing nothing wrong, Arnold. The display format of the data is one thing and the data in the database is another. Why would you want to waste space in the database to store the parentheses, spaces and dash in the phone number when you can interpret it as you wish on output?
John On Fri, Oct 16, 2009 at 7:47 PM, Arnold Roth <[email protected]> wrote: > I have created a form to enter data where one of the fields is a telephone > number. In setting up the table, I entered a custom format as > "("xxx")"xxx"-"xxxx. This shows as I expected (area code in parentheses > followed by the digits) in the format box. > > When I enter phone numbers in the form, they simply appear in the table as > a string of numbers without the formatting. > > Can anyone tell me what I'm doing wrong? Thanks > > Arnold Roth > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
