Convert to Uppercase

[jirrah]

convert to upcase, access 2002

help me convert field to upper case automatically and save in table in access 2002
thanks

 

[Mile-O]

Here's the SQL for an Update Query. Just copy and paste it into the SQL View of the query design in Access and then change MyTable and MyField to the relevant names. Save it and then run the query.

UPDATE [MyTable] SET [MyField] = StrConv([MyField], 1);

 

[Kodo]

use the UCASE function..

expanding on that.. use the UCASE function to make sure that all future entries are entered in uppercase.

 

[jirrah]

plz be simple, i am new, i have table and forms , what about this query updating... how to use UCASE, example would help
THANks

 

[Mile-O]

I'd advise the StrConv() function over the UCASE().

 

[Kodo]

curious.. why?

 

[Kodo]

plz be simple, i am new, i have table and forms , what about this query updating... how to use UCASE, example would help
THANks

is the text that you enter that needs to be uppercase of a standard length? i.e. will the length of the data entered ever change sizes or go beyond a certain length.. ?

 

[jirrah]

just i have field of name of food, which i need to be in capital to store in table,
plz help by example

 

[sudhirhinduja]

StrConv() works!

Well once again thanks to all those posts....

I got my job done wothout starting a new thread!

Thanks,

 

[Janjang]

oh great. but am i need to open the query everytime ? how to make the query auto run ?

TQ

 

[tehNellie]

You should only need to run the query once, from then on you should be ensure the string is in upper case before you insert the data into the table by wrapping the string in strconv()/Ucase() within your form etc.