I have a custom list. I want to, when I add new item the list, characters are automatically converted to uppercase. How to enter characters uppercase in textbox?


I think the best solution would be to create a calculated column and use =UPPER([ColumnName]).

You can read more about that here as well: https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx#sectionSection4

| improve this answer | |

there are couple of ways to do it,

  • easy is to use the Caculated Column as mentioned by "Jordan".
  • use javascript code attached to [column] field edit box which will save the value as Upper values
  • Youcan use a little jQuery to force the upper case. On keyup event, get the string and set it to upper case.
  • use the event handler

    public override void ItemAdded(SPItemEventProperties properties) {
      string val = properties.ListItem["Title"].ToString();
      properties.ListItem["Title"] = val.ToUpper();

| improve this answer | |

2 more options:

Note: I copied the Formula from my Task list

You would think a simple

=IF(  [Task Name]=UPPER([Task Name])  ,true,false)

would do the job, but I never got this to work, it always results in true

A slight alteration does work in a Validation rule

=IF(  EXACT( [Task Name],UPPER([Task Name]) )  ,true,false)
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.