Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object reference to the current control
Message
From
04/06/2002 12:22:23
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00664527
Message ID:
00664566
Views:
21
I assume you only want to work with text boxes so TypeOf limits this accordingly.
Dim ctl As Control

For Each ctl in Controls
   If TypeOf ctl is TextBox Then
      ctl.Text = UCase(ctl.Text)
   End If
Next 'ctl
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform