Warning Message

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

Guest

After testing my form in form view I will try to switch to design view and
the following error pops up: "The field 'tblProgtams.txtShTitle' cannot
contain a Null value because the Required property for this field is set to
True. Enter a value in this field." If someone could hlep me better
understand this error message it would be greatly appreciated.

Sincerely,
James E.
 
j1eggert said:
After testing my form in form view I will try to switch to design
view and the following error pops up: "The field
'tblProgtams.txtShTitle' cannot contain a Null value because the
Required property for this field is set to True. Enter a value in
this field." If someone could hlep me better understand this error
message it would be greatly appreciated.

Sincerely,
James E.
Click to expand...

Offhand, I'd say that when in form view, you "dirtied" the current
record -- that is, you changed the value of one or more of the fields..
When you switched back to design view, Access naturally attempted to
save this record, but couldn't because the field txtShTitle was blank,
but the table definition says this is a required field.
 
Your comment helped. I do have one more question. After I fixed this problem
and tried to switch the form from form view to design view the following
error occurred, "Error Error Evaluation CHECK constraint. In the validation
rule. What does this mean?
 
j1eggert said:
Your comment helped. I do have one more question. After I fixed this
problem and tried to switch the form from form view to design view
the following error occurred, "Error Error Evaluation CHECK
constraint. In the validation rule. What does this mean?
Click to expand...

Is that really the exact text of the error message? It sounds more like
a message that someone programmed into an error-handler.

Is this happening in an MDB file, or in an ADP? The message seems to be
saying that the record can't be saved because the value entered for some
field has failed a validation rule that was put in place for it. Or it
might be a validation rule for the table itself. Either way, I would
think that rule would be specified in the table design, either in the
properties for a field, or for the table itself.
 
I fixed it. Thanks for your help.

Dirk Goldgar said:
Is that really the exact text of the error message? It sounds more like
a message that someone programmed into an error-handler.

Is this happening in an MDB file, or in an ADP? The message seems to be
saying that the record can't be saved because the value entered for some
field has failed a validation rule that was put in place for it. Or it
might be a validation rule for the table itself. Either way, I would
think that rule would be specified in the table design, either in the
properties for a field, or for the table itself.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top