Help!!! Validation Rule

  • Thread starter Thread starter Mike Farmer
  • Start date Start date
M

Mike Farmer

I have finished my database thanks o the assistance of some generous
experts.

I still have one problem remaining. When I pull up the form and move to
the last record, I get: "The value you entered isn't valid for this field"

There are 439 records and I am getting the message on about half, but I
can't find the "bad" data". I suspect the problem may be with the first
field: "File Number" which expects an entry like "000436"

This field is the primary key and is set up as follows:

data Type=text
field size=255
required=yes
allow zero length=no
indexed=yes (No Duplicates)
unicode compression=no
IME Mode=no control
IME Sentence Mode=none

The reason why I suspect this field is that some of the records causing
the error message only have three fields (out of almost sixty)
completed. ie "file number" "last name" "first name" I have reviewed the
data over and over and can't find the problem. I also tried the "test
validation rules" function and it said that everything was fine.

Any assistance will be much appreciated.

Regards,


Mike
 
Mike

Most likely it is not one of the fields you have data in. It is probably
one of the other fields. Check the "Required", "Allow zero length", and
"Indexed" properties of the other fields. If "Required" is yes it means you
can't have a blank in that field. Also true if "Allow zero length" is no.
If "Indexed" is yes (no duplicates) you can't have 2 records with the same
data. A blank would count as data so you can't have 2 records with a blank
in that field.

Kelvin
 
Back
Top