I've tried using validation rules in a table.
Like the rule i set for a field was <4.
I assumed this meant all data entered has to be less than 4 digits.
Happy.
Then i test using a six-digit figure: 245545.
Its still happy!!!!! :mad:
No error.
Am i missing the concept??? :confused:
Furthermore. After setting the rule, my table and query stop being linked...
If i load an entry through query, table doesn't update its info.....
This was not the case before.
What am i not doing??? or maybe: What am i doing wrong??? :confused:
I'm hopeless at this program!!!!!!!
Any help/insight would be HIGHLY appreciated.

< 4 means exactly what it says - the field must contain a value less than 4. It says nothing about digits. If you want to restrict the entry to 4 digits, the rule should be:
>= 1000 And <= 9999
You should always put a value in the validation text field also so your users will get an appropriate message.