.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

InfoPath 2010 - decimal field (2digit) converting large number to scientific notation

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

Hi Everyone,

I hope there is a simple solution to this issue.

We have built an InfoPath form for the web. Data from the form is mapped and written to SQL Server 2008 tables. The values are retrieved when the form is reopened. The form is accessed world wide and uses various currency types. Some of the values that we need in the decimal fields are quite large, e.g. 999,999,999,999,999.00. (we don't use currency sign because different curencies use different signs.)

When the amount shown is entered and saved an error occurs and the values have been converted to scientific notation. The field lengths are long enough for the value but still the scientific notation appears. The largest number that I've been able to enter without it converting is 9,999,999,999.00.

Any thoughts on how this conversion to scientific numbers can be prevented. This only occurs on a web based form.

Thanks in advance for your assistance.



Richard D. Lucky Quatier

View Complete Post

More Related Resource Links

dynamic field in infopath 2010



I want to use dynamic field in info path 2010. Imagine for example i have textbox  that user can input desire data.depent on this textbox i want to create dynamic field.

user input below data:

How many books do you need?   3

then i want had been created this table:(I mean this table had been created with 3 row that user input this value, and user can fill ID,Name,Author & Year)

ID     Name        Author      Year

1        book1     Author1     2005

2        book2     Author2     2009

3        book3    Author3      2010

 Anybody can help me?!

thanx alot.

How to use Managed MetaData field (TaxonomyFieldType) in Infopath 2010?


I created a custom list with Managed Metadata field. Then I have to customize the display/edit forms of this list using Infopath 2010. When I click on the Customize Form button, I received this error : the following fields is not support in infopath sharepoint designer.

can anyone let me know whether there is a workaround for this?

Thank you



Problem with InfoPath 2007 Form opened with InfoPath 2010 - whole number integer not coming into dat


I found an issue when testing existing InfoPath 2007 forms via the Infopath 2010 Designer client.  Integer fields in the form template are publishing to a SharePoint Forms Library and show in the default view.  However, if that library is then used as a Data Connection in another or same form template those integer fields are not displaying or available for selection. 

This is not a problem using the InfoPath 2007 client.  It is not an option to convert the field to text as it could affect existing forms in existing libraries.  Also, existing integer fields are no longer appearing in previously defined SharePoint-based secondary data connections.  Only the ID field still appears.  But, those existing fields still work in the form and are selectable for functions, etc.

Is there a solution to this?

Thanks much!  Mike - www.ProgramNetInc.com


sharepoint number field in list comes with decimal places in dispform


hello guys,

 the sharepoint number field in list comes with 2 decimal places in dispform, like

when I enter number like 12 on new form, when I open the dispform, it shows 12.00

I tried to keep the decimal places to 0  but it didn't work.

Do you guys know anything about this one. I don't want to make it a single line of text.

Infopath 2010 form library - add new field to template

I have a new form library - made some changes used quickpublish and all is good.  I then added a new field (Group) using person/group picker - save form and create a new one - the new field does not show in the Form Library columns - how do I refresh the fields I want to show in my sharepoint form library.  Thank you

How to improve the performance of multiple selection field in Infopath 2010 ?


Hi Infopath experts

I am developing an infopath form that has 4 big multiple selection fields (each field has more than 50 choices). Each time the users select a choice from the muiti-selection field, the form takes a lot of time to response. This only happened with IEs (I am using IE8 now). When I tried it with other browsers (firefox, chrome, safari), the performance increased drastically.

I have seen other people saying that IE has issues with Infopath and IE9 might solve the issues. However, our company won't upgrade to IE9 anytime soon. If anyone has workarounds for this issue, please help me with it

Thank you,



Re: InfoPath 2010 dataconnection to SPList (LookUP field return id)



I designed a form in infopath 2010, created a dataconnection to Sharepoint 2010 List, query and data fields include lookup field.

When i expand field tree (Secondry), i can see following data on mouse hover of the field.

MyXYZField (Field)

DataType (Lookup)

Default Type (None)

I then added a dropdown control on the form , using dropdown properties wizard configure MYXYZField as the source.

When i preview the form i only see dropdown filled with LookupID (1,2,3 etc) instead of the text of the dropdown.


I must be missing something here, please help.










InfoPath 2010 Set field values of multi checkbox based on drop down selection



I have a drop down with e.g values "Fruit", "Veg".I also have checkboxes - "Apple", "Pear", "Orange" ,"Tomato", "Potato". On selection of Fruit i want the checboxes applicable to fruit to be checked. I have a rule at the moment but can only get one checkbox to be ticked. How do i do multiple.

Thanks in advance.




How to convert a decimal number field to C#


I have a SPList with calculated numeric field with 1 decimal digit. Having trouble to convert it to c#. The string representation is like this : "float;2.1000"

Is there a SP builtin class or conversion function to handle this, or do I have to parse this manually?



Bind Infopath 2010 Form Control to another List Field


Hi, I am having Sharepoint 2010 RTM Enterprise Trial on Windows Server 2008 SP2.

I have Two Lists (List1 and List2) and List2 has a lookup field for List1 ID.

I want to bind some of the controls on infopath form of List1 to List2 fields such that when the user enters the values, these values would be saved in List2 and when the user want to edit the data of List1, the values can be retrieved from List2 on Form Load.

can it be done ?

can it be possible without having a field in List1 (direct binding to List2 field) ?


How to Create Auto increment Request number for browser enable infopath form field Programmatically?

hi all,

i have created an infopath which have one request no. field and it will auto increment when click on add new item on sharepoint Document library

field contains (highest value of column request no. +1 )  when infopath will open in browser.

What i have done on this:i have create new data connection on sharepoint library and then pick document library then choose ID field and insert function in the field max(ID)+1.

help me



InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

how to add vailidation between library field and infopath


 i have a browser enable form with filed mails ids and cost i am promoting these filed, and it's saving in library  but i need a vailidation when if any when to submit  requets using mail and cost , at  time i need availidation that your mail id is already  exit , i create a receiving connection for mail id fields it received fileds how to i compare it


While Printing an Infopath Form it Prints lot of Blank Spaces Before RichText Field


I had an infopath form with few rich text field. When i copy some content from somewhere and paste in the richtext Box then while Printing the form I get Lot of Blank Spaces Infront of the rich text box.

I tried creating teh print view too but still i get bunch of empty pages printed before by richtext box control.

Is there a way we can remove those blank spaces.....

I am not able to find out what is going wrong here....

Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverlight 3

Learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverli

Watch the video that accompanies the MSDN article and learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Converting Word Documents to PDF using SharePoint Server 2010 and Word Services (Visual How To)

Watch the video and explore code as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend