Capitalize first letter

[Guest]

Is it possible to capitalize the first letter of every sentence in text
fields? I am not sure but seem to recall that this was possible in Access 2
or 95. EVerything I have seen is related to the first letter of every word
which is not what I am looking for. I expected that autocorrect would work in
Access 2005 (2007) in the same manner as word but this is not the case.

 

[missinglinq via AccessMonster.com]

Goto Tools--AutoCorrect and you should be able to set Capitalize First Word
of Every Sentence.

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

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

The problem with autocorrect is that in this case, the first sentence is
ignored. Anything after the second sentence will be corrected but not the
first. Unfortunately writing is not the strongest ability that the people I
work with have. They would type a very short sentence in a memo field and
will usually be all caps or all lower case. If I force the first letter to be
capital and the rest lower case with code, any words that need to be
capitalized will also be converted.

 

[Dave]

Some code that was provided to me awhile back from this group that may help
you.


'This caps first letter of textbox value
Private Sub TextBox_LostFocus()
Me.TextBox = UCase(Left(Me.TextBox, 1)) &
Right(Me.TextBox,(Len(Me.TextBox)
- 1))
End Sub


'This caps first letter of each word in text box
Private Sub TextBox_LostFocus()
Me.TextBox = StrConv(Me.TextBox, vbProperCase)
End Sub


This Input Mask forces first letter of textbox value to caps

L<????????????

Hope it is of value
Dave

 

[Guest]

The first code did not work and the second does what I don't want.
Capitalizing the first letter of every work is as good as all caps or all
lower case. The Mask limits the field lenght to the size of the mask itself.
Even if the first code had worked it will change other words within the
sentence to lower case (ie: names of people/places). Thanks anyway.