Not allowing users the ability to edit a cell

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

John W. Vinson

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!
 
B

Bernd Gilles

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

RonaldoOneNil

"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
 
R

RonaldoOneNil

Forget my previous post, if it is a control on a form that is a calculation
then you can't edit it anyway.
 
D

De Jager

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