Recent content by juliet123

even if the field is numeric and i use that expression "between..." it doesnt work.... as for that expression of In(....), it doesn'twork....it says something about the character string being too long of something.... But expression "7" Or "8" Or "9" ..........etc does work ... so il just use...

so whats the validation rule then ? sorry, am confused :confused:

yeh thatz what happened to mine as well... wen i put Between "7" And "13" it lets me enter numbers below 7 and above 13....

i tried to do this in my database and it won't work...my field is also set to text....but the validation rule i want is between 7 to 13.... can this only be done in a query or is there also a way to do it in a table? pls help