"Hidden" controls

[GraeagleBill]

An old trick of mine with reports, where field references are needed in the code sheet of the report but not displayed in the report, is to simply create a text-box whose ControlSource is the field of interest and make the control not visible. So, if such a control is created (or left over from an old version of the report) and the field is not included in the RecordSource for the form, one will be prompted for the value when the report opens. My problem is an old report that presumably has some "hidden" controls like I've described here, but I can't find them.

I tried to run this code in the open event:



dim i as integer
for i = 0 to 20
debug.print me.controls(i)
next

Access 2003 does not like the debug statement stating non-supported method. (what's wrong with my code?)

If I can get a list of controls. Is there a way within the report's design mode to delete a control, even if I can't see it?

Thanks,
Bill

[June7]

Try:

Dim ctl As Control
For Each ctl In Me.Controls
    If ctl.ControlType = acTextBox Then
        Debug.Print ctl.Name
    End If
Next ctl
Set ctl = Nothing

[GraeagleBill]

Code worked perfectly. And, I see the three text-boxes that need to be deleted but they are not visible in design view. Is there a way to delete them in code?

[June7]

I don't understand how textboxes cannot be visible in design view. Sounds like corruption. I suggest creating a new form and copy/paste the good controls to the new form. Then delete the old form and rename the new one.

[GraeagleBill]

That was going to be my next move, no pun intended. And yes, I suspect you're right about the corruption.
Thanks,
BIll