Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Access records stored to all uppercase

Status
Not open for further replies.
willfindaway

willfindaway

MIS
Jan 28, 2004
19
US
IS THERE A WAY TO CONVERT ALL THE RECORDS IN MY ACCESS DATABASE TO UPPERCASE. Currently I am using UCASE(string) on my forms which works but i would like to convert all the previous records stored. Thanks again for all your help.
 
Sort by date Sort by votes
You could use an update query and the Ucase function to update existing records.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
500
Andrzejek
Andrzejek
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
403
hermanlaksko
hermanlaksko
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
243
Xavierparkash
Xavierparkash
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
667
dhookom
dhookom
BlakeLacy1
  • Locked
  • Question
COPY ALL FOLDERS AND CONTENTS TO A NEW LOCATION
Replies
4
Views
231
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top