|
View Full Version : Capital Letters In Tables djwasim 06-18-2009, 02:33 AM 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:) darbid 06-18-2009, 04:46 AM edit: sorry posted this incorrectly. WIS 06-18-2009, 11:24 PM 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. khawar 06-19-2009, 08:49 PM On the after update event of text box enter this txt1=ucase(txt1) replace txt1 with your text field name |