not saving records with null values

  • Thread starter Thread starter JOHN
  • Start date Start date
J

JOHN

MVP,
over view of form
on a form i have red field and blue fiels. i want all the
red fields to be required when saving any new records in
my DB. the blue fields are optional. on the red fiels i
set the "validation rule" under "propoties" to "Is Not
Null" because i dont want to form to be able to save a new
record to the DB with out all red fields filled out.



the problem
The validation rule only seem so aply to the first field
on the form. am i doing something wrong...??any ideas?

thanks so much for your help,
JOHN
 
Why not set the fields required in the design of the table.
That should solve the problem.

Jim
 
there are many old record from the old excel spread sheet
that have many blank fiels wont I loose records when a
require not null valuse in fields?
 
JOHN said:
MVP,
over view of form
on a form i have red field and blue fiels. i want all the
red fields to be required when saving any new records in
my DB. the blue fields are optional. on the red fiels i
set the "validation rule" under "propoties" to "Is Not
Null" because i dont want to form to be able to save a new
record to the DB with out all red fields filled out.



the problem
The validation rule only seem so aply to the first field
on the form. am i doing something wrong...??any ideas?
Click to expand...

Make them required in the Table definition. Validation rules for form controls
only apply if you actually enter the control and enter something. If the
control is never given focus, the validation rule doesn't do anything.
 
Back
Top