Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object reference to the current control
Message
General information
Forum:
Microsoft Office
Category:
Access
Title:
Object reference to the current control
Miscellaneous
Thread ID:
00664527
Message ID:
00664527
Views:
52
The Me keyword refers to the current form if you are in a form. Is there a convenient way to get an object reference to the control whose method is executing, other than specifying the name as Me!controlname?

The reason is that I have a bunch of controls that need input values converted to upper case. I don't need any other input mask. I can put code like this:

Me!somecontrolname.Value = UCase(Me!somecontrolname.Value)

in every textbox, but there are a lot of them. What is the right way to do this?
Next
Reply
Map
View

Click here to load this message in the networking platform