empty field

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

Jean-Paul De Winter

Hi,
In the report detail design I have a field: "remarks"
I set this field as "can chrink" and "can grow".
This all works, but, what if the field is empty? It still takes place on the
report printout.
Can I set it so only place is taken when there actually is data in the
field?
Thanks
 
You don't have a "field" on a report, you probably have a "text box" on a
report. Try set the text box border to red to see if the text box actually
takes up space even if it is set to Can Shrink: Yes. If it doesn't shrink
then I expect the value in the field bound to the text box is not null as
you expect.
 
Add to the source of your report another field,
IIf(IsEmpty([remarks]),Null,[remarks]) and bound it to the field in the
report instead of "remarks".
 
Back
Top