Input Mask - Capitalise First Letter ?

  • Thread starter Thread starter andyw
  • Start date Start date
A

andyw

Hi,

I wish to have an input mask which capitalises the first letter of word
of unknown length ?

Is this possible, so far I've only managed to do this if I specify a
certain amount of lowercase letters ?
 
Hi,

I wish to have an input mask which capitalises the first letter of word
of unknown length ?

Is this possible, so far I've only managed to do this if I specify a
certain amount of lowercase letters ?
Click to expand...

Input masks are not capable of doing this. They are simply not a very
capable tool for anything other than limiting allowed data entry!

You can use a bit of VBA code on a Form to force this conversion: use
the AfterUpdate event of the textbox into which the data is entered.

Private Sub textboxname_AfterUpdate()
Me!textboxname = UCase(Left(Me![textboxname], 1) & _
LCase(Mid(Me!textboxname], 2)
End Sub

If this if for names, not that there are names with valid mixed
capitalization such as "de la Renta" and "MacKeith".

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hi,

I wish to have an input mask which capitalises the first letter of word
of unknown length ?

Is this possible, so far I've only managed to do this if I specify a
certain amount of lowercase letters ?
Click to expand...

Don's use a mask.
Code the Control's AfterUpdate event:

[ControlName] = UCase(Left([ControlName],1)) & Mid([ControlName],2)
 
Back
Top