Suppress line when no data

[denis]

Hi,

I've the following problem in Access :
I have created a report as one record per page
I have many fields in the table
But most of them are not filled

Problem is that sometimes one field is compelted, sometimes it is
another field, I can't know that in advance.

Can you please give me the clue to print both label and data when field is
completed, and no label, no data, and even not an empty line in my report
when the field is empty ?

Thanks a lot
Denis

 

[Fons Ponsioen]

I find it the simplest when I combine the label and data
field into one when I want to do what you expressed;
so let's assume we are talking about the phone number, I
would do it like so:
="Phone Number: "+ [PhoneNumber]
You also could set the source to:
=IIF([PhoneNumber] is null, null,"Phone Number: "&
[PhoneNumber])
all on one line
Hope this helps.
Fons