How to have capital characters not changed into lower case?

[AA Arens]

When I fill in the data in a field, capital characters are changed in
lower case. How to solve it?

Like:

Company name: SONY

becomes after Enter or Tab:

Company name: Sony
Bart

[Rich Wills via AccessMonster.com]

In the design menu right click on the field and click on properties change
the setting of "ALLOW AUTO CORRECT" to "NO" this will stop it!

Also if you want to make all the characters lowercase regardless of what the
user inputs put "<" in the "Format" setting and simila for making all
uppercase put ">" in "Format" setting.

Hope this is all you need

Let me know

Rich :)

AA Arens wrote:

When I fill in the data in a field, capital characters are changed in
lower case. How to solve it?

Like:

Company name: SONY

becomes after Enter or Tab:

Company name: Sony

Bart

--
Message posted via http://www.accessmonster.com

[AA Arens]

Thanks, Rich, but when I changed it into "No" there is no change in
result.
Could it be that there is a lock somewhere?
Could you otherwise give me the Event Procedure?
I want to keep my present setting that, when I use lowercase only, the
fist character always changed in to capital.

Bart

[Trevor Best]

AA Arens wrote:

Thanks, Rich, but when I changed it into "No" there is no change in
result.
Could it be that there is a lock somewhere?
Could you otherwise give me the Event Procedure?
I want to keep my present setting that, when I use lowercase only, the
fist character always changed in to capital.

fist character? dem's fightin' words, put up yer dukes :-)

Ctrl+Z undoes autocorrecting.

[Rich via AccessMonster.com]

Hey Bart

The first question is have you got anything in the Format property of the
text box or in the Format Property of the field that the text box is refering
to in your table / query?

If all formats have nothing in them then I will have a look at some code for
you. But I really think there must be something that is making it change.
Check the field properties in the table design also.

Let me know what you can will get beck to you with some other tries.

:)

Rich

AA Arens wrote:

Thanks, Rich, but when I changed it into "No" there is no change in
result.
Could it be that there is a lock somewhere?
Could you otherwise give me the Event Procedure?
I want to keep my present setting that, when I use lowercase only, the
fist character always changed in to capital.

Bart

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1

[AA Arens]

Hi Rich,

No there is no format when:

I click in the field Company Name of the form > right click >
properties > Format > Format.

Go to Tables > Open the table name > Design View > The data type of the
field Company Name is "Text", Format = empty.

Bart

[NoodNutt]

Thats not quite correct, you can AutoCap the first letter of every word in a
control.

Try this: Open a new module and type this in:

Function AutoCap(sInput As String) As String

Dim X As Integer
Dim sWork As String

sWork = Trim(sInput)
Mid(sWork, 1, 1) = UCase(Left(sWork, 1))

For X = 1 To Len(sWork) - 1
If Mid(sWork, X, 1) = " " Then Mid(sWork, X + 1, 1) = UCase(Mid(sWork, X
+ 1, 1))
Next X

AutoCap = sWork

End Function

In the AfterUpdate of your control put this

Me."YourControl" = AutoCap("YourControl")

HTH

Mark.
"AA Arens" <ba***********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi Rich,

No there is no format when:

I click in the field Company Name of the form > right click >
properties > Format > Format.

Go to Tables > Open the table name > Design View > The data type of the
field Company Name is "Text", Format = empty.

Bart