[AccessD] Edit Field Property via Code

Thanks Andy and William
Cheers
Selina

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, December 03, 2003 10:54 PM
Subject: Re: [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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>