Use the Controls Collection

Use the Controls Collection

If you need to reference every control on a form, using the Controlscollection will be faster than referencing every control directly. Forexample, if you have four command buttons on a form and you want to setthe Enabled property to False for all of them, you have two options.
Option 1:

 cmdAdd.Enabled = False cmdEdit.Enabled = False cmdDelete.Enabled = False cmdNext.Enabled = False 

Option 2 will execute approximately 10 to 15 percent faster thanOption 1:

 For iLoop = 0 To 3 Controls(iLoop).Enabled = False Next 
Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular