Value entered isn't valid for this field

  • Thread starter Thread starter Bill Mitchell
  • Start date Start date
B

Bill Mitchell

I have a Microsoft Access 2000 training database that has
a command button that brings in a Class History form.
Most student have multiple classes in their class history.
On a number of students, when I use the advance error to
scroll through their class history, I receive the
error "The value you entered isn't valid for this field."
It does not happen on each record. I am not trying to
change or enter any data, I am just advancing to the next
record when I receive this message. Can anyone offer a
reason why this is happening and a fix.

Thank You
Bill M.
 
Bill,

Check your table definition to determine if the table
allows zero-length strings. Also, check to ensure that
there is no Default Value set for the field on the form.
It could be that you are defining "" (two double quotes
that mean "zero length string" to Access) for the control
in the form. Although you aren't changing the field,
Access may be trying to insert a zero-length string into
the field that is giving you the error.

Read the help on Null values and Zero-Length
Strings....that might help.

Chris
 
Back
Top