This is probably really simple!

[AuroX7]

Hey guys, I'm just wondering how I could limit a field to using from 2 - 20 letters. If I placed the letter "a", I'd get an error saying how at least 2 letters must be there, and a maximum of 20. How would I do this?

Lastly, how can I make it so when I enter data into a form, I can click a button which adds it all into the table?
When I do it normally, it's automatically transferred into the table as I type it into the form.

This is incredibly simple I know, but I am a n00b at Access. ^_^

Thanks guys.

 

[patrickcre8]

Use after update event and use Len() to check the no. of character entered.

and regarding your second question, there are so many way to do that.

you can use SQL command, openrecordset addnew....etc

but the easiest way for u is to insert the table and create an after update event to update all fields at once