Hello all,
I've got a report I have setup to create labels. In the detail section I have 4 text boxes setup as following:
'''''''''Device Header''''''''''''''''''''''''''''''
Name
Location
Text1
text2
'''''''''Detail''''''''''''''''''''''''''''''''''' ''
text3
text4
Text5
Text6

I'm trying to change the visibility dynamically (based on the entries). Basically if IsNull([Text1]) = True I want to make
Detail.Visibility = False but that should be different for each entry. There are three columns per page with 9 possible Device headers (if detail section is empty). I tried using the can shrink property but the problem I come up with is if I have data in text3 and text4 but not text5 and text6 then it shifts the next Device Header up (not good for printing labels). Bottom line. If I have text in text3 I need text4, text5, and text6 to not shrink, but if no text in Text3 to shrink the entire section. I tried to use this code:

Set db = CurrentDb()
Set rst = db.OpenRecordset("Main", dbOpenDynaset)
If (IsNull(rst![Tag2]) And IsNull(rst![Tag3])) Then
    Detail.Visible = False
Else
    Detail.Visible = True
End If
rst.MoveNext

in the code window but it will only run at startup, not per row accessed from the table. Any ideas how to make that code get accessed for each record and make the detail section react dynamically?

Thanks in advance!

Refine your query behind the report.

Add this code to the criteria line in your query for the Text3 field:

<>""

Of course, this will also remove the information for Name, Location, Text1 and Text2.

Create two queries then. One with Name, Location, Text1, Text2.
Then create a second query with the balance of the table using Text3, Text4, Text5, Text6. Then add the first query, link them by the proper field (must be in both queries) and then modify the relationship to show all records in the first query even if there are no matching records in the other table.

Then create the report and put all the data in the Detail section:

Detail:
Name
Location
Text1
Text2
Text3
Text4
Text5
Text6

Then on the detail section's on format event, set the width of the controls to 0 if Text3 is null or blank, and back to whatever it should be (in twips) if it has a value. If this doesn't work, then make them move up a few lines if 3 is blank and make them invisible.

Like that.

I guess there is a better way by removing the controls if 3 is empty.

You might make two reports based on two queries, one with Text3 having a value, and one without. That is the bullet proof way.

Hope this gives you some ideas.

mmcdonal

It Does indeed. Thanks mmcdonal :)