Alter table query query

  • Thread starter Thread starter MikeR
  • Start date Start date
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
 
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]
 
Back
Top