don't prnt empty fields

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
In my report I have a field "remarks"
In 50% of the records this field is empty.
When printing the report always an empty field is printed.
Is there a way to oly print this field when there actually is something in it?

Thanks
JP
 
OK, and what to do with textfields in cases like:

"as a solution to the problem I would suggest:" fallowed by an entryfield
containing data or nothing at all

so, if the entryfield is empty the textfield just before should not be
printed.
(where to find "Can Shrink"?? number of tab, number of item... I have an
foreign language version of access)

Thank you very much
JP
 
Is "as a solution to the problem I would suggest" in its own text box or is
it combined in a text box or is it a label control?
 
it's own text box...
some are "combined"... will that "Can Shrink" work in these situations?
Thanks
 
To shrink a combined expression text box, use "+" rather than "&" to
concatenate. In the "own" text boxes, you can use something like:
="Your own text values " + [Your Field]
Make sure the text box only displays the first part and don't allow it to
grow.
 
Back
Top