Convert To All Caps or First Letter of Each Word?

[scottdev]

Search was down on site - sorry for duplicate. I remember a post on converting data from all caps to first letter of each word as cap, and converting to all caps. Can these be completed in an update query, or does it require some kind of VB code in the table field under the General tab in design view, or either? Seems like I remember needing to copy the table and paste into a new table for the changes to take place using VB. What's the best way to do this?

Either way, any help would be great.

 

[TheAceMan1]

How are ya scottdev . . . . .

[blue]StrConv([purple][b]string[/b][/purple], vbUpperCase)
StrConv([purple][b]string[/b][/purple], vbProperCase)[/blue]

See Ya! . . . . . .

 

[scottdev]

Not sure if I'm setting up this update query right?

Field: product
Table: master_inventory
Update To: "product"=StrConv("product","vbProperCase")
Criteria: ABC Product


Returning Error:
Data type mismatch in criteria expression

 

[KenReay]

Field: product
Table: master_inventory
Update To: [product]=StrConv([product],vbProperCase)
Criteria: ABC Product

or

DoCmd.RunSQL "UPDATE mater_Inventory SET product = StrConv(product,vbProperCase) WHERE Product = 'ABC Product'"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK