Hiding Controls in a report

[Francis Cunningham, Jr.]

Hi,
I have created a report that appears to be a letter, when printed. Data on
the report comes from a Form. On this report I have the controls
"CompanyName' and 'FirstName LastName' (=[FirstName & " " & [LastName].
Sometimes there isn't a Company Name and only a First and Last Name,
sometimes there isn't a First and Last Name only a Company Name. How can I
use both controls and not have a blank spot appear on the finished report.
Can I hide the control with no data in it.
Frank

 

[Jeff Boyce]

Actually, data shown on a report usually comes from the underlying table(s),
perhaps via a query. What is it that you have coming from the form?
(Access tables store data, forms display it)

If you have a control on your report for which there is no underlying data
(in the table), you can set the Can Grow and Can Shrink properties of that
control to "Yes". It will "disappear" (i.e., shrink/close up) when there's
no data ... WARNING: this only works if there are no controls directly
aligned, to the right.

Regards

Jeff Boyce
Microsoft Office/Access MVP