By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,708 Members | 1,570 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,708 IT Pros & Developers. It's quick & easy.

How to convert lowercase to uppercase in Access table

P: 2
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(tMunis);

"HousingTowns" 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".
Jul 21 '06 #1
Share this Question
Share on Google+
6 Replies


100+
P: 179
You use the function UCase.

Example:

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

comteck
Jul 21 '06 #2

P: 2
Many thanks, I will try this. bds
Jul 21 '06 #3

P: 1
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(tMunis);

"HousingTowns" 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!
Nov 1 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
Welcome to TheScripts!

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

Linq ;0)>
Nov 1 '07 #5

P: 1
.................................................. ................

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
Oct 28 '08 #6

missinglinq
Expert 2.5K+
P: 3,532
It's usually placed in the AfterUpdate event of the textbox in question:

Expand|Select|Wrap|Line Numbers
  1. Private Sub YourTextboxName_AfterUpdate()
  2.    Me.YourTextboxName = UCase(Me.YourTextboxName)
  3. End Sub
  4.  
Welcome to Bytes!

Linq ;0)>
Oct 29 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.