Changing Text automatically

  • Thread starter Thread starter Aurora
  • Start date Start date
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
 
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
 
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.
Click to expand...


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