>>>>>Does anyone know of a way to format on input an upper case for the first letter only (as in proper names) of a field. I really don't want to make the whole field upper since I want to use the names for business mailings.
>>>>>
>>>>>Thanks in advance,
>>>>>
>>>>>Sylvia
>>>>
>>>>I think if you put something like "!XXXXXXXXXXX" in your InputMask Property it will do what you want.
>>>Thanks Elyse -
>>>That did the trick. In reading the help, I thought that the ! character in the inputmask would affect the entire field. I must have misunderstood.
>>>Sylvia
>>
>>In the Format Property, the "!" DOES affect the entire field, but in the InputMask it's per-character.
>
>Thanks, I didn't know that. Now is there a shortcut to typing (in my case) 29 "X's" after the "!"? I have a 30 character name field?
You can use REPLICATE.
By the way, you could make an automatic format for your textboxes by placing the following code in the ini() of your texbox baseclass:
*-- For character fields, fill in an input mask that limits the
*-- number of characters than can be typed to the size of the bound field.
IF EMPTY(this.InputMask) AND TYPE(this.ControlSource) == "C"
this.InputMask = REPLICATE("X", ;
FSIZE(SUBSTR(this.ControlSource, AT(".", this.ControlSource) + 1)))
ENDIF
José