How do I force upper case Field entry?

[Geolomax]

I have a form in InfoPath and would like to force a couple of fields to
upper case regardless of what is entered. Doesn't have to be as user types
data in, but can be switched after user moved to next field.

I looked for the UPPER() function but it wasn't available in the function
list. Is there another way to do it?

 

[Michelle B]

Set the default value of the textbox to the formula
translate(., "abc ... z", "ABC ... Z")

where abc ... z is the alphabet. The formula does a 1:1 substitution, so
the third letter in the second string parameter is replaced with the third
letter in the third string parameter

 

[potpourri]

hi there,

I tried using your formula of "translate(., "abc ... z", "ABC ... Z")
but it doesn't work for me.
Could you verify if it's the right formula?

Also, what should I do if I wish to translate only the first characte
of the string to an uppercase?

Ex: "example" becomes "Example" ?


Thanks alot :


-
potpourr

 

[S.Y.M. Wong-A-Ton]

To convert only the first character to upper case, try the solution posted
here:
http://enterprise-solutions.swits.net/infopath/convert-first-letter-word-upper-case.htm

 

[Deb]

S.Y.M:

Thank you so much for this solution! I was looking for the same
information. I'm also looking for a way to automatically format a telephone
number field so that the 10 digits a user enters are formatted as :

(999) 999-9999

Is there a combination of translate and string that can accomplish this?

Thanks for your help!