Sentence Case

[Tom]

Using Access 2002.

I have a memo field into which the user will paste text
into. After pasting I would like the text to convert to
Sentence Case.

Can this be done with the above version of Access. If so
where can I find the code to do this

Thanks in advance

 

[Nick Coe \(UK\)]

Do you mean proper case where every word has it's first
letter capitalised?
Take a look at StrConv() in Access VBA Help. Also see the
Access Web links below:

http://www.mvps.org/access/strings/str0005.htm

http://www.mvps.org/access/strings/str0008.htm

If you mean just the first character in each sentence then
you could modify the code above to change the first
character (leftmost) and then search for periods (full
stops) instead of spaces and change the case of the first
letter character (not space or number etc) after the
period..