How to convert lowercase to uppercase in Access table

[BSHELTON]

How do I convert existing lowercase data to uppercase in Access 2000? I used the following which did not work?

UPDATE HousingTowns
SET tMunis=UPPER(tM unis);

"HousingTow ns" is the table name.
"tMunis" is the field name in which the lowercase text is stored in 154 000 rows.

I get the error message "Undefined function 'UPPER' in expression".

[comteck]

You use the function UCase.

Example:

Dim LowerCaseText, UpperCaseText as String
LowerCaseText = "Hello World 1234" ' String to convert.
UpperCaseText = UCase(LowerCase Text) ' Returns "HELLO WORLD 1234".

comteck

[BSHELTON]

Many thanks, I will try this. bds

[Bass]

How do I convert existing lowercase data to uppercase in Access 2000? I used the following which did not work?

UPDATE HousingTowns
SET tMunis=UPPER(tM unis);

"HousingTow ns" is the table name.
"tMunis" is the field name in which the lowercase text is stored in 154 000 rows.

I get the error message "Undefined function 'UPPER' in expression".

............... ............... ............... ............... ......

you'll do the statement
Ucase(fieldname )
ok...
Email address removed per site rules!

[missinglinq]

Welcome to TheScripts!

Please note that the posting of email addresses is prohibited on TSDN and if posted will be deleted!

Linq ;0)>

[zerxiex16]

............... ............... ............... ............... ......

you'll do the statement
Ucase(fieldname )
ok...
Email address removed per site rules!

excuse me sir.where to put this code Ucase(fieldname ) in access to convert to upercase

[missinglinq]

It's usually placed in the AfterUpdate event of the textbox in question:

Private Sub YourTextboxName_AfterUpdate()
   Me.YourTextboxName = UCase(Me.YourTextboxName)
End Sub

Welcome to Bytes!

Linq ;0)>