How would I change a text field size from 2 to 20 using VBA

thanks

Nigel

Hi:

Try executing SQL like this in VBA

"Alter Table [Category List] Alter Column [ComponentID] Text(10)"

This changes column ComponentID to Text 10 in table Category List.

Regards,

Naresh Nichani
Microsoft Access MVP

"Nigel Bennett" <(E-Mail Removed)> wrote in message
news:029501c51ad9$04b4a460$(E-Mail Removed)...
> How would I change a text field size from 2 to 20 using VBA
>
> thanks
>
> Nigel