Alter table query query

M

MikeR

I can alter a data type with this statement.
ALTER TABLE settings
ALTER COLUMN age text(20)

With an ALTER TABLE query, can I AllowZeroLength=True (or set any of the other properties)?

Thanks,
MikeR
 
J

John Vinson

I can alter a data type with this statement.
ALTER TABLE settings
ALTER COLUMN age text(20)

With an ALTER TABLE query, can I AllowZeroLength=True (or set any of the other properties)?

Thanks,
MikeR
Click to expand...

I don't believe so, not in a JET database. You'll need to use VBA
code.

John W. Vinson[MVP]
 
Top