deleting a field

[Bre-x]

Hi,

can a Table field be delete by VBA?

Thank you all

Bre-x

 

[Jeff Boyce]

Given that any particular field in any table may be connected to queries,
forms, macros, pages, and code, are you certain you want to do that? How
will you also ensure that everything connected to that field doesn't
"break"?

 

[Bre-x]

Hi Jeff,

Thanks for answering my post. Yes I am 100% sure, I just need to delete the
field.

 

[Dan Artuso]

Okay, if you're %100 sure, here the secret incantation:

CurrentDb.TableDefs("Notes").Fields.Delete ("Title")

Just substitute your table and field names