Do Not Allow change to default value

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a date field for the date an entry is logged in a
table. The default value is Date(). This field should
not be updatable, it fills in automatically when a record
is added. Can this be restricted? Right now I am able to
change the date.
 
I have a date field for the date an entry is logged in a
table. The default value is Date(). This field should
not be updatable, it fills in automatically when a record
is added. Can this be restricted? Right now I am able to
change the date.
Click to expand...

You must use a Form to allow this constraint - and you should be doing
so in any case; users should generally never even SEE a table
datasheet, much less update it!

Just create a Form based on your table, and set the properties of the
control displaying the datefield to Enabled = No, Locked = Yes.
 
Back
Top