Upper Case letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Acc 2003. I pasted an inventory into my fields and they are all upper
case. Is there a way to change these to first letter of each word upper case
without retyping it all? Imported: TOPAZ BRACELET Would like: Topaz
Bracelet
 
Hi Laura,

Try this:

strconv("ABCDE ADFASDF", vbProperCase)

ie: strconv(FIELDNAME, vbProperCase)

Damian.
 
lauras03 said:
I use Acc 2003. I pasted an inventory into my fields and they are all upper
case. Is there a way to change these to first letter of each word upper
case
without retyping it all? Imported: TOPAZ BRACELET Would like: Topaz
Bracelet
Click to expand...

Create a Query based on your table. Let's say this fieldname is ItemName;
select only this one field.

Change the query to an Update query using the Query menu option or the query
type dropdown tool.

On the UpdateTo line put

StrConv([ItemName], 3)

Run the query by clicking the ! icon.

Damian's suggestion is the same thing, it's just that vbProperCase is a
Visual Basic constant for the number 3 - and it's not available in queries.

John W. Vinson [MVP]
 
Back
Top