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

[Dishy78]

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

[missinglinq]

To allow Zeros:

[YourFieldName] Mod 4=0

To not allow Zeros:

[YourFieldName] Mod 4=0 And > 0


Welcome to TheScripts!

Linq ;0)>

[Dishy78]

Thanks for that

Trish :-)

[missinglinq]

Glad we could help!

Linq ;0)>

[NeoPa]

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.