Hide empty text boxes

[Guest]

I select records using a combo box on the form header. I have text boxes on a
subform that display the fields of the selected record.

I want to hide all text boxes on the subform that don't contain data.

Thank you

 

[Graham Mandeno]

Hi Peter

You can set each control's Visible property in the Form_Current event
procedure.

SomeControl.Visible = Not IsNull(SomeControl)

If you have a number of these, you could use the control's Tag property to
identify it as a candidate for checking. For example:

Dim ctl as Control
For Each ctl in Me.Controls
If ctl.Tag = "X" then ctl.Visible = Not IsNull(ctl)
Next ctl

Note that you can't make a control invisible if it currently has the focus,
so first SetFocus to one that is not a candidate.

Also, if your subform is continuous then this will affect the controls in
all records.

 

[Guest]

Thanks for the help Graham--your solution worked fine.