[AccessD] Edit Field Property via Code

Hi Selina
Whilst developing the BEU (which sounds like something you may want to take
a look at if you do this sort of thing a lot - exactly what it was designed
for, see http://www.databaseadvisors.com/downloads.htm) we found that
modifying field lengths was not supported via code. However you can do it
with an ALTER TABLE command in latewr versions of Access. I think it's W2K
onwards that allows it, I just know for sure that A97 doesn't. But that's
where to look.

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] Edit Field Property via Code
Date: 03/12/03 03:42


Good Evening Everyone
I have several databases being used across town and I need to send out an
update which will increase an existing text field size 15 characters to be
25 characters. I can add fields, but cannot figure out how to edit them.
If someone could help I would truely appreciate it.
Thanks heaps
Selina


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

________________________________________________
Message sent using UebiMiau 2.7.2