Upper Case letters

[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

 

[Guest]

Hi Laura,

Try this:

strconv("ABCDE ADFASDF", vbProperCase)

ie: strconv(FIELDNAME, vbProperCase)

Damian.

 

[Guest]

Where do I put this?
--
Thanks,
Laura

Hi Laura,

Try this:

strconv("ABCDE ADFASDF", vbProperCase)

ie: strconv(FIELDNAME, vbProperCase)

Damian.

 

[John W. Vinson/MVP]

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

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]