Thanks jomali. I'm such an idiot. That should have been obvious but it got
right by me.
----- Original Message -----
From: "jomali" <[email protected]>
Newsgroups: gmane.comp.openoffice.questions
To: <[email protected]>
Sent: Saturday, October 17, 2009 9:46 AM
Subject: Re: Special formats in Base
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
