Capitalize first letter

D

DLR_Graph

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.
 
M

missinglinq via AccessMonster.com

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

Dimas Perez

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.
 
D

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
 
D

Dimas Perez

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top