[AccessD] Caps Lock

Thanks a lot Brett the KeyPress event works just great, just what I
needed.  Sometimes I just get a brain lock and it is great to have this
list to help me get by it.

Thanks again

Mike Gowey, MCSA, A+
Team Leader - SRCI
Information Systems & Services Division


-----Original Message-----
From: Brett Barabash [mailto:BBarabash at TappeConstruction.com] 
Sent: Monday, January 05, 2004 10:43 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Caps Lock


Mike,
You can specify this in the field's InputMask property with a > symbol
(lookup input mask in help for further details).

Or, in the KeyPress event, you can put the code:
KeyAscii = Asc(UCase$(Chr$(KeyAscii)))

While it is possible to set the Caps Lock state through an API call,
this is considered a poor practice as it interferes with other apps.
I'll keep my conscience clean by not posting that solution here.


-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Monday, January 05, 2004 11:32 AM
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

------------------------------------------------------------------------
--------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
originator of the message. This footer also confirms that this email
message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual sender,
except where the sender specifies and with authority, states them to be
the views of Tappe Construction Co.

Scanning of this message and addition of this footer is performed by
SurfControl E-mail Filter software in conjunction with 
virus detection software.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com