AutoCorrect

[Roger Bell]

I have used the TOOLS-AUTOCORRECT and clicked "Capitalize first letter of
sentence". The properties of the field are set to allow autocorrect. When I
type a name EG: smith in lower case, the s of smith does not Capitalize.

Any help would be appreciated

 

[Duane Hookom]

Is this an Access question? Is "smith" the first word of a sentence?

 

[Roger Bell]

Yes Duane, this is an Access Question and smith is the first word of the
sentence
Any clues? thanks

 

[John Spencer]

Interesting. I just tested this and once I have a period (or other sentence
ending punctuation ? !) then autocorrect starts capitalizing the first word
of any sentences after the FIRST occurence of the period plus space. But it
doesn't work for any text before the first period.

 

[Roger Bell]

Yes John, I get exactly the same. Bug or what? Someone must know the answer
Thanks

 

[John Spencer]

I would guess it is by design. This is a database and controls don't
normally contain sentences but discrete bits of information. That said, the
idea seems to be don't autocorrect the first word in a sentence until we
know we have a sentence. In a word processor, a sentence is the norm, in a
database a sentence is an exception.

That is all speculation on my part. You could write a bit of VBA to
automatically upper case the first character in the control if it is
important to you.