Field Format.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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])
 
THANKS!!!!!!!!!!!!!!!!

fredg said:
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.
Click to expand...

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])
Click to expand...
 
Back
Top