>>>>>>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é

Thanks Jose -
I like your suggestion. Did you mean the Init() event?
Sylvia