Charlotte Foust
cfoust at infostatsystems.com
Tue Aug 12 16:38:08 CDT 2003
You can do an update query and use the Lcase() function, but are there just particular fields you want to do this on? Otherwise, you would have to create a query that updated each field to the Lcase() value of that field. Charlotte Foust -----Original Message----- From: Melissa F. Sener [mailto:melissasener at earthlink.net] Sent: Tuesday, August 12, 2003 1:23 PM To: Access Developers discussion and problem solving Subject: [AccessD] How can I change my table to include on characters inlowercase? How can I change my table to include on characters in lowercase? Is there a way to run a macro to convert any uppercase to lower case? I need it actually changed in the table not just displayed as lowercase. Thanx Melissa _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com