Locking a field

  • Thread starter Thread starter KLR
  • Start date Start date
K

KLR

I have created a database and am typing the information
into a table rather than a form (a lot of the fields are
duplicated and it is easier to copy and paste in a table).

I have one column however that contains a list of codes
that were imported from Excel - this information needs to
be protected so accidental changes cannot be made. I
know that it is possible to protect a field in a form,
but I need to do the same in a table and can't figure out
how.

Can someone please help.
 
KLR said:
I have created a database and am typing the information
into a table rather than a form (a lot of the fields are
duplicated and it is easier to copy and paste in a table).

I have one column however that contains a list of codes
that were imported from Excel - this information needs to
be protected so accidental changes cannot be made. I
know that it is possible to protect a field in a form,
but I need to do the same in a table and can't figure out
how.

Can someone please help.
Click to expand...

You can't do that in a table. Create a query and for that column wrap the
value in an expression that returns the same result. That will make the
column read only. If it's a text field for example you could use...

NewColumn: [YourFieldName] & ""
 
Back
Top