How do I turn off the caps lock on a form?

[Linda Davies]

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

 

[Jeanette Cunningham]

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

 

[Linda Davies]

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.

 

[Steve Schapel]

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.

 

[Linq Adams via AccessMonster.com]

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?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Steve Schapel]

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.

 

[Linq Adams via AccessMonster.com]

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com