Upper Case Data acceptance irrespective of CAPS Lock status

[Guest]

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

 

[Peter Hibbs]

Vikas,

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

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

HTH

Peter Hibbs.

 

[Guest]

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

hth

 

[John W. Vinson]

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]

 

[Guest]

Hi John,

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