CAPS

[Iram]

Hello,
Is there anyway that I can place a rule on a field or on a form to make the
data that is entered into CAPS letters?


The data is looking really ugly with uppers and lowers....


Thanks.
Iram/mcp

 

[Stuart McCall]

Hello,
Is there anyway that I can place a rule on a field or on a form to make
the
data that is entered into CAPS letters?


The data is looking really ugly with uppers and lowers....


Thanks.
Iram/mcp

Put the following code into the keypress event of your textbox:

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

That will convert anything entered into upper case as the user types.

 

[Dennis]

Iram,

In the field's (control's) After Update event, you can put the code:


me.FieldName = UCase(my.FieldName)

or

me.FieldName.Value = UCase(my.FieldName.Value)




You might also want to look at this page:


http://www.vb123.com/toolshed/05_access/upperlowercase.htm


Good Luck.

Dennis

 

[Iram]

Dennis and Stewart, you guys are awesome!

I don't know what I would do with out this newsgroup!


Thanks.
Iram/mcp