don't prnt empty fields

  • Thread starter Jean-Paul De Winter
  • 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
 
J

Jean-Paul De WInter

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
 
D

Duane Hookom

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?
 
J

Jean-Paul De Winter

it's own text box...
some are "combined"... will that "Can Shrink" work in these situations?
Thanks
 
D

Duane Hookom

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