[AccessD] change field size in code

thanks for the quick response.
can I use some wild card chars in the Where .....?



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Wednesday, April 12, 2006 9:20 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] change field size in code


ALTER TABLE tblname
ALTER COLUMN colname Memo
WHERE colname.value = "comment"

If this is just a one-time change, you should be able to run it from the SQL
View window -- you don't even need DAO.

Susan H.

Could someone give me some air code to change the field size from text to
memo if the word "comment" is in the field name?
Attached table. A2K. Preferably dao, I'm kinda old school.
A last minute change from the client.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com