Differences between Disabled and Locked on a form control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CW - 15 Jul 2007 14:14 GMT

I am aware of the basic effect of Enabled yes/no on a control on a form, and
have used it to create read-only fields that pull values from other forms
just for info purposes.
But what are the differences, the pros and cons, between Enabled and Locked?
When should I use one or t'other? And in what combinations?
I will be very grateful if somebody could please explain this (n.b. on-board
Help doesn't find either term!)
Many thanks
CW

Reply to this Message

Rick Brandt - 15 Jul 2007 14:25 GMT

>I am aware of the basic effect of Enabled yes/no on a control on a form, and
> have used it to create read-only fields that pull values from other forms
[quoted text clipped - 5 lines]
> Many thanks
> CW

Enabled has to do with whether the user can place focus on the control. Locked
influences whether they can change the value. If you have a control that you
want to be read-only, but where the user might find it handy to be able to copy
the control's value to the clipboard, then you would use Locked = Yes rather
than Enabled = No.

Enabled = No (by itself) also changes the appearance of the control so if you
don't want that to happen you would use Locked = Yes or both Locked = Yes and
Enabled = No.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

CW - 15 Jul 2007 15:04 GMT

Great explanation -all clear to me now
Many thanks
CW

> >I am aware of the basic effect of Enabled yes/no on a control on a form, and
> > have used it to create read-only fields that pull values from other forms
[quoted text clipped - 15 lines]
> don't want that to happen you would use Locked = Yes or both Locked = Yes and
> Enabled = No.

Reply to this Message

Allen Browne - 15 Jul 2007 14:26 GMT

Enabled Locked Use
====== ===== ===
Yes Yes Normal, editable control
Yes No Display, allow focus and copy, but not edit.
No Yes No focus, no copy, normal display.
No No No focus, no copy, dimmed appearance.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I am aware of the basic effect of Enabled yes/no on a control on a form,
>and
[quoted text clipped - 8 lines]
> Many thanks
> CW

Reply to this Message

CW - 15 Jul 2007 15:06 GMT

Great summary - many thanks Allen
CW

> Enabled Locked Use
> ====== ===== ===
[quoted text clipped - 15 lines]
> > Many thanks
> > CW

Reply to this Message

missinglinq - 15 Jul 2007 15:07 GMT

You might want to look at that again, Allen!

>Enabled Locked Use
>====== ===== ===
[quoted text clipped - 8 lines]
>> Many thanks
>> CW

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message