- Go to text box properties.
- Click on fx button beside default value box.
- Click on insert function. And select translate function.
- Select the text box field as the first parameter,
Ramblings of a Naija Blogger, Techie, Sharepoint Evangelist, Graphic Artist and Budding Photographer
Monday, September 30, 2013
Enforcing capital letter of every word - InfoPath 2010
Use the translate function to convert the letters to Capital.
How to enforce captalisation of first letters of any word in Infopath Forms
- In InfoPath 2010, create a new Blank Form template.
- On the Home tab under the Controls group, click Text Box to add a text box control to the form template.
- Click the text box control to select it.
- On the Properties tab under the Properties group, click Default Value.
- On the Field or Group Properties dialog box on the Data tab in the Default Value section, click the Insert Formula button behind the Value text box.
- On the Insert Formula dialog box, type in the following formula into the Formula text box, and click OK.
concat(translate(substring(., 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring(., 2, string-length(.) - 1)) - On the Field or Group Properties dialog box, click OK.
- Press F5 to preview the InfoPath form.
Subscribe to:
Posts (Atom)