August 8, 200223 yr Hello I have a database that I use to print mail labels and recently my agency requested that I now print the labels with all upper case print. I have simple text fields ie.. Business Name, and Contact 1.. these have information that is not formatted to all upper case, I searched around the forums and I am not sure how I can take all 2000 records and convert them to upper casing.. I see a function named upper("text") but I am not even sure if it will do what I need please help.. kkalvin26
August 8, 200223 yr Well, here is a down and dirty solution: Use a font that only has upper case letters. Then all the info will be printed in upper case......... HTH Jack
August 8, 200223 yr Upper () will do what you are looking for, although I would instead suggest that you simple format the fields on the label as Uppercase.
Create an account or sign in to comment