Display a field in a form that cannot be edited from the form.

[Guest]

I have a form that I use to edit the data in a table that has 7 fields.
I wish to have 3 of the fields viewable but not editable from the form.
And I wish to be able to view and edit the other 4 fields from the form.
I do not know how to do this, and I would appreciate any help.
Thank you very much!

Adam

 

[Rick Brandt]

I have a form that I use to edit the data in a table that has 7
fields. I wish to have 3 of the fields viewable but not editable from
the form. And I wish to be able to view and edit the other 4 fields
from the form. I do not know how to do this, and I would appreciate
any help.
Thank you very much!

Adam

Set the Locked property of the controls to Yes.

 

[Guest]

For the fields you want to be read-only set the controls' Enabled property to
False (No) and their Locked property to True (Yes). The controls will appear
as normal but the user won't be able to edit them, or even move focus to them.

Ken Sheridan
Stafford, England