Capitalizing the First character of a name using input mask

[n_m]

Hi,

Am trying to do the above & am finding that '> ' function capitalizes all the letters - is there any way of forcing caps on the first character?

Thanks in advance

 

[Ayman_Khoshouey]

Hi,

Am trying to do the above & am finding that '> ' function capitalizes all the letters - is there any way of forcing caps on the first character?

Thanks in advance

Try this in Field Properties---> Input Mask
!>L<??????!>L<????????!>L<??????????

It allows you (6) Chr's for the first name - (8) Chr's for a middle name and (10) Chr's for the last name. (You can change num. as you wish).

Ayman

 

[welshgasman]

Just use Ucase(Left(textfield),1) and concatenate the rest?

 

[Micron]

Input masks are somewhat limited so code is often best. But maybe like
>?<?????>?<?????????>?<?????????

 

[Joe4]

Ayman,
FYI, this thread is from 2005! (You must have had to really dig deep to find this)!

 

[Micron]

Crikey, I blame WGM. Apparently he should be enjoying Corona or tequila in Mexico instead of lurking in forums. Then again, that could explain why he didn't notice that.

 

[welshgasman]

Crikey, I blame WGM. Apparently he should be enjoying Corona or tequila in Mexico instead of lurking in forums. Then again, that could explain why he didn't notice that.

To be fair, the poster before me resurrected it and I admit I never noticed . Sorry guys.

@Micron I am a Dos Equis man BTW

 

[Joe4]

To be fair, the poster before me resurrected it and I admit I never noticed . Sorry guys.

That is why my reply was not directed at you!

I think it was the case of a solution in search of a question.

 

[SalimSD]

very intersting