Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / January 2006

Tip: Looking for answers? Try searching our database.

infopath strips leading zeros from input

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Will - 06 Jan 2006 20:45 GMT
I have a text box bound to a string.  When I input numbers with leading
zeros into the box, infopath strips away the zeros.  Is there a way to
stop this from happening so that I can store strings like "01" and
"001"?

Thanks
Greg Collins [InfoPath MVP] - 09 Jan 2006 17:44 GMT
You likely have your field datatype as a whole number. If you set the datatype to text, then it will store the zeros.

Signature

Greg Collins [InfoPath MVP]
Visit http://www.InfoPathDev.com

I have a text box bound to a string.  When I input numbers with leading
zeros into the box, infopath strips away the zeros.  Is there a way to
stop this from happening so that I can store strings like "01" and
"001"?

Thanks
Will - 09 Jan 2006 21:29 GMT
Thanks for the response Greg.

My form is actually based on an external schema.  The test box was
originally bound to a number, but I changed it to a string in the
schema.  After converting the data source, it seems some of the
number-related formatting was still left in the infopath xsl.  I
deleted the text box and created a new one which fixed the problem.

Thanks again.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.