adding field to record using command_click

[susan]

Hi,

How can I add a Yes/No-field to a record using a Command_click() ?
Is it also possible to check if the field already excists before adding it?

Thanks,

Susan

 

[Allen Browne]

Susan, you really should switch your table to design view to add new fields.

Access 2007 does actually allow you to add new fields while the table is
open in datasheet view (shudder!!!), but no one who knows what they are
doing would ever use this misguided 'feature'.

If you have a table with lots of yes/no fields, there's a very high probably
that you have created a spreadsheet design in Access, i.e. you have not
built it the way a database should be designed. For details, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html