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 / May 2007

Tip: Looking for answers? Try searching our database.

How do you stop Text fields from auto formatting numbers?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 08 May 2007 19:46 GMT
Hi,

How can I stop a text field from automatically formatting user data?  For
instance, my main data source has a text field called product number.  The
form has a text box with the data type set to "Text (string)".

If a user enters A025600 as the product number everything is fine.  However,
if the user enters 025600 it automatically gets converted to 25,600 - which
is not good.

How can I stop InfoPath from automatically formatting the user data?
Aruna - 09 May 2007 06:35 GMT
Hi Steve,

If you set the data type of text field to “Text (string)” then it will not
truncate the number.
I have a question for you. Are you converting this text field into integer
in code?
I tried your scenario, it is working correctly for me.

> Hi,
>
[quoted text clipped - 7 lines]
>
> How can I stop InfoPath from automatically formatting the user data?
Steve - 09 May 2007 15:32 GMT
Thanks Aruna,

Not sure what was happening or if there could have been a cached form
template or something, but you're right, it's not truncating the number
(string) anymore.  

To answer your question, no I'm not coverting it in code.

> Hi Steve,
>
[quoted text clipped - 15 lines]
> >
> > How can I stop InfoPath from automatically formatting the user data?
 
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.