Lock Unlock Command Button

[Guest]

I'm using a command button to flip the state of AllowEdits
by using a Click event with:
Me.AllowEdits = Not Me.AllowEdits

I'd like the command button change when selected. Something like: Lock -
Unlock

Any suggestions?

 

[Guest]

If you mean change its caption no promblem. You can simply use code like:

Me.CommandButtonName.Caption = "WhateverYoudLike"

Daniel

 

[Guest]

Just as an alternative, and depending (of course) on your situation, you
might consider using an option group with the push button style. One push
button for "lock", and one for "unlock".

Sometimes it adds to the visual appeal to vary the controls you use a little.

Just my opinion,
CW

 

[Guest]

Thanks a bunch, very helpful. I've rated the responses. Thanks again