Bob Gajewski
rbgajewski at adelphia.net
Mon Jan 5 11:44:53 CST 2004
Mike If you only care about displaying upper case in a form or report, you can just use the Format property (" > ") of the field. If you want the data stored in upper case, you can always use CBF during input: *********************************** Private Sub YourField_AfterUpdate() YourField = UCase(YourField) End Sub *********************************** Regards, Bob Gajewski -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gowey Mike W Sent: Monday, January 05, 2004 12:32 To: Access Developers discussion and problem solving Subject: [AccessD] Caps Lock Hello Everyone, Is there a way in Access to make a field automatically be capitalized or a way to make the caps lock key come on when the database is opened? Thanks in advance for any help. Mike Gowey, MCSA, A+ Team Leader - SRCI Information Systems & Services Division _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com