Unanswered: Enable all text boxes - more foolproof method?
I have written the following code:
Dim c As Control
For Each c In Form
If left(c.Name, 3) = "txt" Then
c.Enabled = True
c.Locked = False
Obviously this works fine providing all text boxes follow the naming convention of a txt prefix. Is there a better way of doing it - i.e a way of testing that the control is a textbox rather than assuming from the name?
If you were still on the protege list you would have learnt by now to always throw in any snippets casually (and ideally with a hint of disdain) as though you wrote the functionality a few years ago yourself as opposed to having just hastily consulted google.
But you are not so you are destined to continue making all these errors during your short career in IT.