basic update query

[antonyx]

hi..

quick question...

i want to update all the records in a certain field..

to make the first letter of each word a capital

to make every letter a capital

i know how to make un update query, what to i put in the criteria if the field is called

field1

cheers

 

[Brianwarnock]

I think you mean in the Update to field not criteria

StrConv([field1],3)
if using microsoft's function
or

functionname([field1)

if you have your own custom function

Brian

 

[Brianwarnock]

hi..

quick question...


to make the first letter of each word a capital

to make every letter a capital


cheers

Just noticed this conflict, which is it?
Brian

 

[antonyx]

yes sorry.. i meant the update to field..

i wanted 1 call to make the first letter of each word a capital letter..

and 1 call to make all letters capital

so i wanted both calls for field1

 

[Brianwarnock]

Ok to make all capital change the 3 to a 1 in the first example, as per help on StrConv, tho there is a function Ucase I think, so you could try that.

The important thing is to put the field name in[] even if there are no spaces and when using StrConv use the integer not vbProperCase or similar which doesn't seem to work.

Brian

 

[rhett7660]

Brianwarnock..

Thank you that is what I was looking for!!!!

Thanks