 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007How do I turn off the caps lock on a form?
Hi - I added a new field to my Form, but the default for the form seems to be only CAPS. I need this new filed to have both upper and lower case letters (as well as numbers). Thanks Hi Linda, Where are you seeing only CAPS? If the new control is a textbox, when the user types in the textbox, does the entry format as all caps? Are you seeing caps in design view of the form? Jeanette Cunningham > Hi - I added a new field to my Form, but the default for the form seems to > be > only CAPS. I need this new filed to have both upper and lower case > letters > (as well as numbers). Thanks Yes, when the user types in the textbox it defaults to all caps. I don't know where to look for caps in the design view - I looked under properties, but didn't see an option to change that. > Hi Linda, > Where are you seeing only CAPS? [quoted text clipped - 9 lines] > > letters > > (as well as numbers). Thanks Linda, Have a look in the Format property. Look in both the properties for the field in design view of the table, and also in the design view of the form. It might look like this: > If not, we will look elsewhere for the problem. For example, there may be a macro or VBA procedure that is doing this.  SignatureSteve Schapel, Microsoft Access MVP > Yes, when the user types in the textbox it defaults to all caps. I don't > know where to look for caps in the design view - I looked under properties, > but didn't see an option to change that. Is this the only form demonstrating this behavior? If so, go into Design View, verify that CapsLock is off, then run the form. Does the behavior persist? You can check for the > formatting as Steve suggested, but I doubt that this is the culprit, since you created a textbox and the problem is there. You would have had to intentionally added this formatting to the new control; this is not something that would be added by default.. And finally, is this database all your doing, or did you inherit it? Have you copy/pasted code from elsewhere? SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 > You would have had to intentionally added this formatting to the new control; > this is not something that would be added by default.. Nope. Could be in the Format of the field in the table. SignatureSteve Schapel, Microsoft Access MVP >Nope. Could be in the Format of the field in the table. True, it could be in the Format of the field in the table, but this formatting is never done by default! It still had to have been placed there by someone during development! Hence the question about inheriting the database. It's also possible that CapsLock have been turned on throughout the db; hence the question about whether other forms are affected or not. SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.