Forums

This topic is locked

Telephone Numbers and Zip Code formats

Posted 31 Jan 2002 23:23:58
1
has voted
31 Jan 2002 23:23:58 A. B. posted:
I am useing UD 4 with an Access 2000 database. I have the telephone number and zip code fields displayed and stored in the correct format in the database. However, when the UD recordset is displayed, the numbers run together (like this: 7192623325).

Would someone please tell me how I can display the telephone number and zip codes correctly? I don't see a way with UD to format the output.

Thank you in advance!

-Andrea

Replies

Replied 01 Feb 2002 09:49:21
01 Feb 2002 09:49:21 Viktor Farcic replied:
You haven't wrote how do you want them to be displayed. To separate two DB fields: Insert > Special Characters > Non-Breaking Space.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am useing UD 4 with an Access 2000 database. I have the telephone number and zip code fields displayed and stored in the correct format in the database. However, when the UD recordset is displayed, the numbers run together (like this: 7192623325).

Would someone please tell me how I can display the telephone number and zip codes correctly? I don't see a way with UD to format the output.

Thank you in advance!

-Andrea
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 01 Feb 2002 09:50:01

Edited by - vfarcic on 01 Feb 2002 09:50:32
Replied 01 Feb 2002 15:08:03
01 Feb 2002 15:08:03 A. B. replied:
Thank you, Viktor, for your suggestions. This is how I would like the data displayed:

telephone number - (719) 262-3325
zip code - 72215-4016

Thank you again!

-Andrea
Replied 01 Feb 2002 18:31:22
01 Feb 2002 18:31:22 Viktor Farcic replied:
You can use 'Left', 'Right' and 'Middle' commands.
Place this (using Code View) somewhere on a page:
&lt;%
Dim strZIP
strZIP = (TableName.Fields.Item("ZIPField".Value)
Response.Write("(" & Left(strZIP, 5) & "-" & Left(strZIP, 4)
%&gt;

I suppose you've got the picture.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Thank you, Viktor, for your suggestions. This is how I would like the data displayed:

telephone number - (719) 262-3325
zip code - 72215-4016

Thank you again!

-Andrea
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager
Replied 05 Feb 2002 12:00:31
05 Feb 2002 12:00:31 b w replied:
What about if the data is a dynamic text or text field?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
You can use 'Left', 'Right' and 'Middle' commands.
Place this (using Code View) somewhere on a page:
&lt;%
Dim strZIP
strZIP = (TableName.Fields.Item("ZIPField".Value)
Response.Write("(" & Left(strZIP, 5) & "-" & Left(strZIP, 4)
%&gt;

I suppose you've got the picture.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Thank you, Viktor, for your suggestions. This is how I would like the data displayed:

telephone number - (719) 262-3325
zip code - 72215-4016

Thank you again!

-Andrea
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Reply to this topic