Not allowing users the ability to edit a cell

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

Hi there

In my database, I have included an age calculation as a control source.

How do I set it up so that users can not make changes to this variable?

Thank you in advance for your help.
 
Hi there

In my database, I have included an age calculation as a control source.

How do I set it up so that users can not make changes to this variable?

Thank you in advance for your help.
Click to expand...

If the Control Source of the textbox is a calculated expression, it's not
editable. You don't have to do anything to prevent editing - in fact you
cannot make it editable!
 
John said:
If the Control Source of the textbox is a calculated expression, it's not
editable. You don't have to do anything to prevent editing - in fact you
cannot make it editable!
Click to expand...

and on the data sheet of the property window you can set active=false and locked=true so the user
cannot even click into this field ... this will avoid error messages.
 
"In my database" I assume you to mean on a form as you should not put
calculations in a table. Just set the property "Locked" of the control on
your form to Yes
 
Forget my previous post, if it is a control on a form that is a calculation
then you can't edit it anyway.
 
forest8 said:
Hi there

In my database, I have included an age calculation as a control source.

How do I set it up so that users can not make changes to this variable?

Thank you in advance for your help.
Click to expand...
 
Back
Top