I probably should not answer a question I don't understand.
Allow null value and set Required sounds like a contradiction to me.
In any case, you can CreateTableDef(), CreateField, and set the properties
with DAO.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"SAN CAZIANO" <al**********@tin.it> wrote in message
news:d7**********@balena.cs.interbusiness.it...
how can i create a runtime table and define a new field to allow null
value
and set the rquired to true or false ???