How do I program a report so if nothing is entered in a text box it is made invisible when printed.

[Ronald Cangro]

In my report I have a section where I list standards I have used in the report. There is room for 5 instruments to be listed. If I only used one instrument, I would like the remaining 4 blank lines to be made invisible when printed.

Standards Used

Instrument

The 4 lines that don't have anything in them should be eliminated.

Standards Used

Instrument

Thank you,
Ron Cangro

[Bulzie]

Make this field a subreport (page header has title and field in Body as continuous form). Add it to your main report and in property sheet of the object, select Can Grow"Yes" and Can Shrink "Yes". See if that works, it did on my testing. Just remember though that any other objects you have on the report below this subreport will be moved around depending on how much that box shrinks or grows. If you have the room, might just want to show all 5 lines.

[June7]

Why would there even be blank lines? Each instrument is a field instead of a record?

[Welshgasman]

Do not have then in the source in the first place.