Need to detect a click on a locked/disabled control

Question

I have a field that for certain users cannot be updated. In these cases, I set the control to Locked = True and Enabled = False. I want to be able to inform the users when they cannot modify this control so if they click on it, I want to display a message. My click event is never firing. I'm assuming my settings are preventing it. How should I do this? Thanks.

Answer 1

You'll have to set Enabled to True, otherwise clicks won't register.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

I believe you could place a transparent command button on top of the control, and use the Click event of that button to do what you want.

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html