Formatting text field to all caps - InfoPath Dev Sign in | Join | Help in Newbie Questions InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Newbie Questions » Formatting text field to all caps Formatting text field to all caps Last post 04-30-2009 09:49 AM by DavidSea2. 4 replies. Page 1 of 1 (5 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 04-30-2009 07:30 AM DavidSea2 Joined on 03-06-2009 West Palm Beach, FL Posts 14 Formatting text field to all caps Reply Contact Is there a way to automatically format a text field to all caps? David Filed under: formating, newbie questions, data validation 04-30-2009 07:58 AM In reply to ErnestoM Joined on 08-27-2007 Posts 3,320 Re: Formatting text field to all caps Mark as Not AnswerMark as Answer... Reply Contact I don't believe InfoPath 2007 has font formatting for all caps. You could create rules that find lower case and replace then with upper case. Ernesto MachadoQdabra® Software/ InfoPathDev.comThe InfoPath Experts – Streamline data gathering to turn process into knowledge.™ 04-30-2009 08:10 AM In reply to DavidSea2 Joined on 03-06-2009 West Palm Beach, FL Posts 14 Re: Formatting text field to all caps Mark as Not AnswerMark as Answer... Reply Contact Where would I put the rule and how would it work? David 04-30-2009 08:14 AM In reply to Jimmy Joined on 07-03-2008 Posts 2,595 Re: Formatting text field to all caps Mark as Not AnswerMark as Answer... Reply Contact You can do this by placing a rule on the field: Set a field's value (select the field itself) Formula: translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ") Jimmy Rishe / Software Developer / Microsoft MVPQdabra Software 04-30-2009 09:49 AM In reply to DavidSea2 Joined on 03-06-2009 West Palm Beach, FL Posts 14 Re: Formatting text field to all caps Mark as Not AnswerMark as Answer... Reply Contact Thank you - I haven't seen the translate() function before - I'll be able to use that on other issues - Thanks again David Page 1 of 1 (5 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Is there a way to automatically format a text field to all caps?
I don't believe InfoPath 2007 has font formatting for all caps. You could create rules that find lower case and replace then with upper case.
Where would I put the rule and how would it work?
You can do this by placing a rule on the field:
Set a field's value (select the field itself) Formula: translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")
Set a field's value (select the field itself)
Formula: translate(., "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")
Thank you - I haven't seen the translate() function before - I'll be able to use that on other issues - Thanks again