Do Not Allow change to default value

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.
 
J

John Vinson

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top