.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

Hide Commas in Number Field when Editing via DataView

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint

I have a list that contains a number field that I am using to capture a numeric value, however I do not want the values displayed with commas (I am using the number column type to keep the user from entering text)  I am displaying the number field in a dataview on which I have enabled the Insert/Edit options.  When the user is inserting a new record the field does not display commas.  When the dataview is in display mode I am able to change the formatting of the value to remove the commas.  Unfortunately, I can not figure out how to remove the commas from the text box when the user is editing an existing entry.

MOSS 2007, SPD 2007


View Complete Post

More Related Resource Links

conditionally hide a field in a custom form using SharePoint Designer

I'm able to hide a field based on a security group. but, how do you hide a field based on a value in another field? Custom form opens, if fieldTwo = "taco", hide fieldOne.    

DataView WebPart with lookup and person field

Hi I want to insert a dataview webpart, using REST, referring to a list with look-up fields and people fields. The results I receive are the ID's instead of the values. How can I get back the corresponding values? TIA Sjokke

How can I remove/hide built-in Title field in list definition

Now I'm customize a new Content and then new List Template, just like below definition;  <ContentType ID="0x0100ed096ab35eeb4d2e98fb71b9842e9616" Name="Staff Member" Group="Berry Gardens Internet">  <FieldRefs>   <FieldRef ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Name="Title" />   <FieldRef ID="{F5E777EA-C083-4c2f-BC10-E4BF2B4D6372}" Name="Synopsis" />   <FieldRef ID="{2307576C-A060-4c2d-BABC-34E5A9924667}" Name="Image" />   <FieldRef ID="{051B830A-8105-4384-9AA1-103CEE43B760}" Name="Email Address" />  </FieldRefs> </ContentType> It is inherit from Item parent type, and using built-in Title field({fa564e0f-0c70-4ab9-b863-0177e6ddd247}), but I found that it's diffcult to remove/hide it. When in the default list view, there are two Title fields. So what can I do in the list definition. Regards upzone    

Custom field and editing

I have created a custom field and have it added to a list.  I created the usercontrol and it work beautifully in the editform.aspx page.  The problem come in that I also want this field to be also used with folders.  From the object model I have added the metadata to that field for the folder, but when I edit the properties of the folder, the control will not show in the editform.aspx.  Can I get it to show for folders? Can I create some custom aspx page that will show it?  I know that you can create folders based on other content types, but that will not work for me. I am working with existing lists. 

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.

Limit number of characters in the view field



I wonder if I can limit number of characters that are being displayed in the view.  For example, one of the columns sometimes has very long description.  I want people to see only 300 characters, and if they want to read more, they have to click on the link to go to details.

Is it possible?

Thank you.

how to hide some value depending on field

i have measures of tons and ctdmtl; I need to calculate grade by dividing the ctdmtl by tons in the measure.

SharePoint Edit Form Shows Field Tabs over Field Item - How Can I Hide These


I am working with a custom edit form in SharePoint designer and I notice that when the form is displayed it shows the form field title in the column on the left and also in a tab directly above each field in the column on the right.  My question is how do I remove those tabs? IOW I just want to show the form field title on the left and the form field on the right; I don't want those grey tabs above the form field.

Tom Molskow SharePoint Architect - If I solved the issue please propose my reply as the answer - Thanks!

DetailsView - Change field size for easier editing


Hi All

Very new to VS2010

I've got data in a DetailsView control which shows the data and expands the rows to suit the content.

However, when I click to edit the information, the editing area changes to just a few characters wide.

How do I change the size of the editing area to match the view data state?

Thanks for helping!



hide the field value in pie chart


I am showing the below values in pie chart

rcode   Value
r1         34
r2         47
r3         56

but i want to hide the r3 value in Pie Chart axis

How to hide approval status field?


Hi all

I have created a custom list in sharepoint 2007.

In dispform.aspx I get to see the "approval status", which I want to hide. I can not find it if I open the SharePoint designer, or in the site columns.
How can this field be hidden?

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?



hide datetime field from NewForm of a list using javascript


I want to hide Datetime control (entire row) from Newform.aspx of a list using javascript. i am using the following code but its not working for Date time field  else its working fine for TextField.

var DateOfwin=document.getElementById(getTagFromIdentifier('input','DateTimeFieldDate','Date of Win').id);

(above code only hide the calander field i want to hide the entire row)


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


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

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



Enabling editing on dataview created from linked data source



I'm working with MOSS 2007. Created a linked data source using 2 custom lists in the site and created a dataview. One of the columns shows a joined subview of the 2nd list from the linked data source. I'd like to enable the editing option (edit, insert) for this joined subview, but that option seems to be disabled (grayed out). In fact, the editing option is disabled for the main dataview as well.

Has anyone done something similar to this? Please advise.





Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.
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