General

Re: Zero first in a text box.

devkiat — Fri, 23 Sep 2011 03:13:28 GMT

another way is to make your datatype to string then add this in the formula substring-after(concat("x", 100000 + 123), "x1") this results to: 100000+123 = 100123 x100123 00123 i use 'x' only as a marker happy programming :)

Re: Zero first in a text box.

Hilary Stoupa — Sun, 19 Oct 2008 14:37:20 GMT

You are correct that the format button is disabled for string data types, but in my test, the leading zero remained for a browser form.

I created a simple browser form with a text field. I published the form. When I opened it and filled it out, the leading zero remained in my text box:

Perhaps you should try re-adding your field?

Re: Zero first in a text box.

dipesh — Sun, 19 Oct 2008 08:31:24 GMT

even it data type of field is string. it wil remove the leading zeros on browser.

note: format button is disable by default for string datatype in infopath.

Re: Zero first in a text box.

BrownR — Mon, 04 Apr 2005 19:43:25 GMT

Ok Greg,
The only way i could solve it was to replace the text feild with a new field. Same settings as the deleted one but now it works. Thanks for the reply. I love this site. What happened a couple weeks ago, i couldnt get on.

Re: Zero first in a text box.

Greg Collins — Tue, 29 Mar 2005 23:00:15 GMT

If the field is formatted as a number, the leading zero gets dropped. If it has formatted turned off (None), the leading zeros will remain.

Greg Collins [InfoPath MVP]
InfoPathDev

Zero first in a text box.

BrownR — Tue, 29 Mar 2005 15:47:04 GMT

I have an arrey of text boxs that hold numbers. In some of the boxs a number maybe inputed starting with a zero. Right now some of the boxs drop the zero and other dont. Ive made sure the data types are varchars in SQL 2000 but they still drop the zero, but other boxs dont drop it. What do i need to look for to see why they are differant.