Access 2000- Change upper case to lower case

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Frank C

Thread Starter
Joined
Jan 17, 2003
Messages
6
I created a list of companies & phone #'s etc. in access 2000. The letters are upper case. How do I change upper case listings to lower case?
 
Joined
Feb 12, 2001
Messages
3,420
Run an UPDATE query using the LOWER() function:

From the help:

LOWER
Converts all uppercase letters in a text string to lowercase letters.

Syntax

LOWER(text)

Text is the text you want to convert to lowercase. Characters in Text that are not letters are not changed.

There is also a PROPER() function that will do the following:

ACME, INC. to Acme, Inc.
 
Joined
Feb 12, 2001
Messages
3,420
UPDATE [MyTable]
SET [MyTable].[MyField] = LOWER([MyTable].[MyField]);
 
Joined
Feb 12, 2001
Messages
3,420
After you have created the query, there is a drop down on the menu bar that says "Query Type". If you drop that down and select "Update Query" it will change it.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top