Changing Text automatically

A

Aurora

I am using Word and Access 2003.
In Word there is a command "Change Case" that allows you to change text to
all caps, all lowercase, Sentence mode etc. I have that command in my
toolbar and use it to change text that is not in the right format.

Is there is a command in Access 2003 that will do the same thing for me
either in reports and/or in the form view? I would appreciate any help
anyone can give me.

Aurora
 
J

John Spencer (MVP)

Take a look at the strConv function also LCase and UCase.

strConv("This String needs to Change,1)
will convert the string to all upper case

Replace 1 with 2 for all lowercase
Replace 1 with 3 for First Letter Of Each Word Capitalized.

Sentence mode is NOT available, although you can write a custom VBA function
to do that.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
M

Marshall Barton

Aurora said:
I am using Word and Access 2003.
In Word there is a command "Change Case" that allows you to change text to
all caps, all lowercase, Sentence mode etc. I have that command in my
toolbar and use it to change text that is not in the right format.

Is there is a command in Access 2003 that will do the same thing for me
either in reports and/or in the form view? I would appreciate any help
anyone can give me.


Not that I am aware of. When I need to do that sort of
thing, I use the StrConv function (see VBA Help).
 

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