Canshrink question!!

[JHB]

Hi:

I am developing a report which contains a line (yes a full line) of
"comments". The "Comments" field is set as a "memo" and may or may not
have data in it. I am trying to set the report up so that when there
is NO data in the "comments" field the line is does not print on the
report. I have set the field in the report to "Canshrink", and it is
the only field on the line.

In theory when the field does not contain data it should not appear on
the report. However, no matter what I do it DOES appear even when the
field is empty. Do memo fields have some sort of weird default, or
could there be another issue around?

Thanks for your help.

Regards

John Baker

 

[patty]

Hi:

I am developing a report which contains a line (yes a full line) of
"comments". The "Comments" field is set as a "memo" and may or may not
have data in it. I am trying to set the report up so that when there
is NO data in the "comments" field the line is does not print on the
report. I have set the field in the report to "Canshrink", and it is
the only field on the line.

In theory when the field does not contain data it should not appear on
the report. However, no matter what I do it DOES appear even when the
field is empty. Do memo fields have some sort of weird default, or
could there be another issue around?

Thanks for your help.

Regards

John Baker

I usually create a query and in the comments field I add the criteria

 

[Access Developer]

You said that is the only _field_ on the line. Is it the only _control_ on
the same line? Vertical overlap with any control... even a line or
rectangle... will prevent shrinking.