Loop through all text boxes on a form

[armesca]

I have about 25 text boxes that get populated based on a financial transaction; quite often about half of them are empty. i wanted to gray them out if they are emtpy (.enabled = false). I could put a series of IF statements in the vba for each one, but its bulky and time-consuming. I've done for each record in tables and recordsets. Is there a way to do a for each textbox on a form? Or is there a simpler way to accomplish this? Any thoughts are appreciated.

-Chirs

 

[bob fitz]

I think you could do it with Conditional Formatting

 

[TJPoorman]

You could also do this in vba:

dim ctl as control
 
for each ctl in me
    if typeof ctl is textbox or typeof ctl is combobox then
        if nz(ctl, "") = "" then
            ctl.enabled = false
        end if
    end if
next

 

[armesca]

The looping through textboxes is great; conditional formatting is slow