Field Format.

[KAnoe]

I have two fields that I would like to set the format on. One is the First
Name. I would like to set it so that ONLY the first letter is a capital
letter. The field size is 50. I see that I can do this >L<LL but i must do
the letters after the first one 49 times and then the user must use all 50
spaces.

The second one I would like all Caps. Again if i use the >L< I must do it 50
times.

Any help would be great.

 

[fredg]

I have two fields that I would like to set the format on. One is the First
Name. I would like to set it so that ONLY the first letter is a capital
letter. The field size is 50. I see that I can do this >L<LL but i must do
the letters after the first one 49 times and then the user must use all 50
spaces.

The second one I would like all Caps. Again if i use the >L< I must do it 50
times.

Any help would be great.

Let the user enter both names however they wish
(remove the >L<LL etc. Input Mask)

Code the [FirstName] AfterUpdate event:
Me![FirstName] = StrConv([FirstName],3)

Code the [LastName] AfterUpdate event:
Me![LastName] = UCase([LastName])

 

[KAnoe]

THANKS!!!!!!!!!!!!!!!!

I have two fields that I would like to set the format on. One is the First
Name. I would like to set it so that ONLY the first letter is a capital
letter. The field size is 50. I see that I can do this >L<LL but i must do
the letters after the first one 49 times and then the user must use all 50
spaces.

The second one I would like all Caps. Again if i use the >L< I must do it 50
times.

Any help would be great.

Let the user enter both names however they wish
(remove the >L<LL etc. Input Mask)

Code the [FirstName] AfterUpdate event:
Me![FirstName] = StrConv([FirstName],3)

Code the [LastName] AfterUpdate event:
Me![LastName] = UCase([LastName])