2. ASPRunnerPro General questions
  3. Custom Format
This topic is locked

Custom Format

 		2/28/2007 12:34:41 PM
ASPRunnerPro General questions
B
 bnnetwork author

I have a zip code field that is not displaying the dash when I build the project and then view the records, it is in the database with the dash though. Is there a way to format this field using the 'Custom' option under the field's properties? I would like for it to display like: 12345-6789.... currently, it is displaying 123456789.
Is there a way to do this?
J
 		Jane 3/2/2007

You can do it using Custom format on the "View as" settings dialog. Here is a sample:

str1 = Left(strValue,5)

str2 = Right(strValue,4)

strValue = str1 & "-" & str2