Actually, in VBA code
If ctl.Value Is Null Then
would have to be
If IsNull(ctl.Value) Then
Robeen has given you the general type of code for looping through all Textboxes on a Form and taking some action, but exactly how you'd need to implement this code depends on exactly what your situation is, something you haven't shared with us! A clear explanation of what you're attempting to do would help us help you!
For most situations, you'd have to at least Call a Function to execute this code, from the AfterUpdate event of each of the 26 Textboxes. It would be a simple
Call MyFunctionName
but it would have to be in the AfterUpdate event of each Textbox.
If the situation simply required that once a Value was entered into any Control, all other Controls would become Disabled and stay Disabled, for ever and ever, you could put the code in the Form_Dirty event.
Like I said, it just depends on your exact situation!
As Oliver Twist requested, "Please, sir, I want some more!"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007