Table Validation Rule for a Field Name

Y

yourmomentofzen

Hi all-

Maybe i'm just a little lousy with this, but i'm having an issue with
the validation rule.

right now i have a field entitled "rainincr" for rain increment and
i'm trying to do a range check, because occasionally there'll be
glitches where it shows the rain at 100" for the day and of course
that's not right, since we don't get monsoons in florida. so in the
validation rule in the properties menu, i put <=10 Or Is Null" but
when i run the table, it still shows up with values such as 30 and
what not still.

any ideas? thanks in advance.

-ymoz-
 
J

Jerry Whittle

Validation rules run on new data. You'll have to fix any existing problems.

Is the field a number or text datatype? If text, all bets are off.

Are you talking about a table or query here?
 
Y

yourmomentofzen

Validation rules run on new data. You'll have to fix any existing problems.

Is the field a number or text datatype? If text, all bets are off.

Are you talking about a table or query here?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.









- Show quoted text -
Click to expand...

It's a table, and the fields are numbers.
 
J

Jerry Whittle

Hi,

Using Access 2003 I created a similar validation rule in a table. When I
saved the table design change, Access checked the Data Integrity rules. It
found data that didn't meet the validation rule but I said to continue. It
did not delete any existing records nor change any data. In other words,
Access did not mess with existing data.

However when I tried to enter a new record that did not meet the validation
rule, it wouldn't let me save the record. This is how Access works. It will
keep existing data that doesn't meet the validation rule; however, it will
not allow any new records nor updates to existing records that doesn't match
the validation rule.

If this is different than what you experienced, I'd like to know more.
 
Top