MS Access 2166 - Cannot Lock Control While It has Unsaved Changes

[ironfelix717]

Hi,

I searched. Can't seem to find a solution.

I am attempting to lock an Option Group (frame) when a textbox property contains any text.

I tried changing the focus back and fourth between the textbox and the option group...

Please see attached with code.



Thanks for your help.TBChange.accdb

[davegri]

Felix-davegri-v01.zip

See if this works for you. Changed the textbox event from on_change to after_update. On_Change fires for every keystroke, not what you want.
Added code to guarantee that the Enter key will leave the textbox, and not just create multiple lines.

[ironfelix717]

Felix-davegri-v01.zip

See if this works for you. Changed the textbox event from on_change to after_update. On_Change fires for every keystroke, not what you want.
Added code to guarantee that the Enter key will leave the textbox, and not just create multiple lines.

Davegri,

Thanks, however, I do want the event to fire after every keystroke. Enter is another step I don't want the user to have to take. Its compromising design, which is why I did not use afterupdate event. But your solution is better than none.

Nonetheless, I have changed the design a bit so I am no longer required to lock the option group. But it appears with is not possible with this event. No solution online exists for locking a control with textbox change events. At least when doing with frames.

Regards,

[June7]

I thought this resolved in https://www.accessforums.net/showthread.php?t=74619

What has changed?

[ironfelix717]

Hi June7,

I shouldve posted code.

Instead of setting enable property in the event, I am now setting locked property instead. This throws the error and to all my research is not possible for whatever reason.

[davegri]

Attachment 36318

Try this one.

[June7]

Why is Locked preferred over Enabled? Locking just adds confusion to user because control still looks available. Tab Stop even still works to allow focus on the control. Enabled set to False eliminates both.