View Single Post
  #2 (permalink)  
Old December 21st, 2005, 01:58 PM
mmcdonal mmcdonal is offline
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You might try turning that field into a string since even though it has numbers in it, it is a string (zip codes are not calculated.)

The problem with vbscript is that it is typeless until you start pulling data, and then it makes a best guess - unless you type it.

To correct this, pull the data in that field using "CStr()". This will turn that field into a string value, and the "-" won't be read as a minus sign.

HTH

mmcdonal
Reply With Quote