[AccessD] How can I change my table to include on characters inlowercase?

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


More information about the AccessD mailing list