Suppress line when no data

  • Thread starter Thread starter denis
  • Start date Start date
D

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
 
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
 
Back
Top