Capital Letters In Tables

djwasim

Registered User.
Local time
Today, 20:56
Joined
May 29, 2009
Messages
93
is it possible that i enter any letter in table/form like 1,2,3,4,5......... or a,b,D,e,f,G........
or any other letter that would convert into capital letters automatically.

Like A,B,C,D,E,F,G..................

Plz reply me as soon as possible

Thanx
Dj Wasim Shahzad:)
 
edit: sorry posted this incorrectly.
 
Last edited:
is it possible that i enter any letter in table/form like 1,2,3,4,5......... or a,b,D,e,f,G........
or any other letter that would convert into capital letters automatically.

Like A,B,C,D,E,F,G..................

Plz reply me as soon as possible

Thanx
Dj Wasim Shahzad:)

In the Format ppty of the fld in the tbl put ">" (without the ""). Also put it in the appropriate ctrl on the frm.

Note: If you have A2003 SP3 this will NOT work due to a "bug" - you have to apply the "hotfix" first.
 
On the after update event of text box enter this

txt1=ucase(txt1)

replace txt1 with your text field name
 

Users who are viewing this thread

Back
Top Bottom