I am creating a DB with access 2002 and I have to create the DDL for the tables involved. Is it possible in access to implement the 'format' and 'input mask' attributes of a field in SQL or does this have to be done manually afterwards?

Thanks

At least in my opinion, the "format" and the "input mask" attributes are something that the GUI deals with, not the data engine. As such, they ought to be dealt with in the language doing the GUI (in the case of MS-Access that would be VBA), not the language doing the data management (in the case of MS-Access that would be Jet, a pseudo-SQL).

-PatP

Thanks, that's what i thought wold be the case.