Can I set the size for Access 2010 number fields?

Question

I am working on a project for a class, and it involves creating some Access 2010 and DB tables. The instructor requests specific sizes for a long integer field. I understand how to set this for numbers in SQL, but not in access. It seems that the size can be set for the text, but not for the number, so I was wondering if there is a way to set the size in these fields in Access 2010?

Answer 1

You can set validation rules, for example:

< 9999 

In MS Access 2010 and beyond, you can also use data macros .

Finally, you can set the restriction through DDL and VBA (see my notes at the end of the article.)