Restrict field in databasse without VBA or SQL

[mohdsh]

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

[jforbes]

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.

[zmbd]

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.

[NeoPa]

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.