Upper Case Data acceptance irrespective of CAPS Lock status

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vikas Kale - 06 Nov 2007 07:30 GMT

I want my data should be entered (in text box object) only in capital letters
irrespective of Caps Lock status. Is it possible??????

Reply to this Message

Peter Hibbs - 06 Nov 2007 08:53 GMT

Vikas,

Add the following code to the KeyPress event of your Text box.

KeyAscii = Asc(UCase(Chr(KeyAscii)))

HTH

Peter Hibbs.

>I want my data should be entered (in text box object) only in capital letters
>irrespective of Caps Lock status. Is it possible??????

Reply to this Message

Maurice - 06 Nov 2007 20:55 GMT

Set the format property of the textbox to > (greater-sign). That should
present tha data as you wish no matter the caps-lock.

hth

Signature

Maurice Ausum

> I want my data should be entered (in text box object) only in capital letters
> irrespective of Caps Lock status. Is it possible??????

Reply to this Message

John W. Vinson - 06 Nov 2007 22:18 GMT

>Set the format property of the textbox to > (greater-sign). That should
>present tha data as you wish no matter the caps-lock.
>
>hth

Just note that this format *displays* the data in all caps. What's actually
stored in the table is what's typed, as typed - lower case, upper case or
mixed case as the case may be.

John W. Vinson [MVP]

Reply to this Message

Maurice - 08 Nov 2007 19:18 GMT

Hi John,

I know the point you are making. I just assumed poster wanted capitals in
the textbox as shown on the form..

Signature

Maurice Ausum

> >Set the format property of the textbox to > (greater-sign). That should
> >present tha data as you wish no matter the caps-lock.
[quoted text clipped - 6 lines]
>
> John W. Vinson [MVP]

Reply to this Message