Forums
This topic is locked
Telephone Numbers and Zip Code formats
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
<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
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:
<%
Dim strZIP
strZIP = (TableName.Fields.Item("ZIPField".Value)
Response.Write("(" & Left(strZIP, 5) & "-" & Left(strZIP, 4)
%>
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
Place this (using Code View) somewhere on a page:
<%
Dim strZIP
strZIP = (TableName.Fields.Item("ZIPField".Value)
Response.Write("(" & Left(strZIP, 5) & "-" & Left(strZIP, 4)
%>
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:
<%
Dim strZIP
strZIP = (TableName.Fields.Item("ZIPField".Value)
Response.Write("(" & Left(strZIP, 5) & "-" & Left(strZIP, 4)
%>
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>
<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:
<%
Dim strZIP
strZIP = (TableName.Fields.Item("ZIPField".Value)
Response.Write("(" & Left(strZIP, 5) & "-" & Left(strZIP, 4)
%>
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>