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

Expression for validation rule in field to force user to enter multiples of #

P: 2
Hi

This is my first time on this site. I have searched help, microsoft, goggle and this forum but cannot find an answer to the following - I'm hoping you can help....

I'm using Access 2003 and would like to use a validation rule of a field name in a table that will only allow a value to be entered if it's a multiply of 4. Is this possible and if so could you let me know what the expression is?

Also, as a side thought, does anyone know of any websites that have a listing of different expressions that can be used (for future reference). I have come across multiple websites that show ValidationRules and ValidationText for: <>0; >1000 Or Is Null; Like "A???"; >= #1/1/96# And <#1/1/97#; etc, but have yet to find any that elaborate on this and talk about all the different possibilities.

Any help you can give is much appreciated

Cheers

Trish
Feb 20 '08 #1
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
To allow Zeros:

[YourFieldName] Mod 4=0

To not allow Zeros:

[YourFieldName] Mod 4=0 And > 0


Welcome to TheScripts!

Linq ;0)>
Feb 20 '08 #2

P: 2
Thanks for that

Trish :-)
Feb 20 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Feb 20 '08 #4

NeoPa
Expert Mod 15k+
P: 31,306
If you go to where you can enter a Validation Rule (Table design / F6 / Select Validation Rule) then hit F1, you should see a fair explanation.
Feb 21 '08 #5

Post your reply

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