SHORTCUT FOR AN INPUT MASK?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FARAZ QURESHI - 22 Jul 2007 17:26 GMT

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?

Reply to this Message

Wayne-I-M - 22 Jul 2007 18:18 GMT

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

Signature

Wayne
Manchester, England.

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

Reply to this Message

Wayne-I-M - 22 Jul 2007 18:22 GMT

ooops - should be

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

Signature

Wayne
Manchester, England.

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

Reply to this Message

FARAZ QURESHI - 22 Jul 2007 18:50 GMT

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.

> ooops - should be
>
[quoted text clipped - 5 lines]
> > input mask option but for a field of 50 siza do I have to insert "C" 50
> > times? Can't there be a shortcut?

Reply to this Message

John W. Vinson - 22 Jul 2007 21:57 GMT

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

Reply to this Message

JanetS - 28 Nov 2008 12:00 GMT

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.

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

Reply to this Message