By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,044 Members | 1,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,044 IT Pros & Developers. It's quick & easy.

Restrict field in databasse without VBA or SQL

P: 1
Hi,

Friends i am quite new to ms access just want to know if in forms some entry field can be restricted without VBA or Sql?

Answer is highly appreciated..

Many thanks
May 6 '15 #1
Share this Question
Share on Google+
3 Replies


jforbes
Expert 100+
P: 1,107
You can use Validation Rules for some basic validation. There is some pretty good information at http://allenbrowne.com/ValidationRule.html there is also this from Microsoft https://support.office.com/en-us/art...f-e3a0272e988d

If your requirements go beyond what is available through Validation Rules, you'll need to resort to some kind of coding. And just a personal preference, it's best not to mix and match using validation rules and coding.
May 6 '15 #2

zmbd
Expert Mod 5K+
P: 5,397
jforbes: ... And just a personal preference, it's best not to mix and match using validation rules and coding.
"second that"
In the distant past... I've caused myself no end of misery by mixing the two when the code would stall.
May 6 '15 #3

NeoPa
Expert Mod 15k+
P: 31,769
An alternative, that you can use with Validation Rules, is to use the Input Mask. It won't work in all circumstances but can in many.
May 6 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.