SHORTCUT FOR AN INPUT MASK?

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

Guest

I want all the text to appear in a field in upper case. I can use ">C" in the
input mask option but for a field of 50 siza do I have to insert "C" 50
times? Can't there be a shortcut?
 
Hi Faraz

I wouldn't use an input mask. Input masks do not stop your users from
storeing lower case so if its important don't use them.

I have used the on KeyPress event to change the lower to upercase in some
address fields in some of my DB's.

Private Sub ControlName_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub

Note - change ControlName to the name of your text box


Or you could use the afterupdate like this

Private Sub ControlName_AfterUpdate()
Me!ControlName = UCase([State])
End Sub

Note - same as above - change the controlname


Good luck
 
ooops - should be


Private Sub ControlName_AfterUpdate()
Me!ControlName = UCase([ControlName])
End Sub
 
Thanx Wayne,

Shall try it soon enough when I am at the stage of preparing forms.
Currently I am only at the Table and Database structure designing level.

Wayne-I-M said:
ooops - should be


Private Sub ControlName_AfterUpdate()
Me!ControlName = UCase([ControlName])
End Sub

--
Wayne
Manchester, England.



FARAZ QURESHI said:
I want all the text to appear in a field in upper case. I can use ">C" in the
input mask option but for a field of 50 siza do I have to insert "C" 50
times? Can't there be a shortcut?
Click to expand...
Click to expand...
 
I want all the text to appear in a field in upper case. I can use ">C" in the
input mask option but for a field of 50 siza do I have to insert "C" 50
times? Can't there be a shortcut?
Yes.
Click to expand...

as a mask.

John W. Vinson [MVP]
 
Instead of using an input mask - just put the greater than sign (the >
symbol) in the FORMAT property. That way - no matter how the user types the
names - they show up (in all tables, forms, query results, reports, etc) in
all uppercase.
 
Back
Top