error in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open my form and move from record to record I get the following error
"The value you entered isn't valid for this field" Do you know why I am
getting this error?
 
When I open my form and move from record to record I get the following error
"The value you entered isn't valid for this field" Do you know why I am
getting this error?
Click to expand...

Because you're trying to enter some value (perhaps from a Default
Value property, perhaps from code) into a field for which the value
isn't valid - e.g. storing text into a numeric field.

Without knowing more about the form, it's impossible to tell any more
than that.

John W. Vinson[MVP]
 
Is there any way of finding out which field it is that is giving us this error?
Click to expand...

Not that I know of. Try opening the form in design view; check the
properties of each bound control, and see if the DefaultValue property
contains something inappropriate for the field. One possible cause is
if you have Lookup Fields defined in your table; they will need a
number as the Default Value, not the text that you might expect from
looking at the (misleading) table datasheet view.

John W. Vinson[MVP]
 
Back
Top