SHORTCUT FOR AN INPUT MASK? in Access Database General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
FARAZ QURESHI 7/22/2007 9:25 AM PST
  Question
  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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Wayne-I-M  7/22/2007 10:16 AM PST
   
  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

--
Wayne
Manchester, England.



"FARAZ QURESHI" wrote:

> 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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Wayne-I-M  7/22/2007 10:20 AM PST
  Answer
  ooops - should be


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

--
Wayne
Manchester, England.



"FARAZ QURESHI" wrote:

> 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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
FARAZ QURESHI 7/22/2007 10:48 AM PST
   
  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" wrote:

> ooops - should be
>
>
> Private Sub ControlName_AfterUpdate()
> Me!ControlName = UCase([ControlName])
> End Sub
>
> --
> Wayne
> Manchester, England.
>
>
>
> "FARAZ QURESHI" wrote:
>
> > 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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
John W. Vinson 7/22/2007 2:00 PM PST
  Answer
  On Sun, 22 Jul 2007 09:26:00 -0700, FARAZ QURESHI
<FARAZQURESHI@discussions.microsoft.com> wrote:

>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.

>

as a mask.

John W. Vinson [MVP]
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
JanetS 11/28/2008 3:59 AM PST
   
  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.


"FARAZ QURESHI" wrote:

> 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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies