Can Shrink Field Still Showing

[Guest]

I have a report with a field "notes" that is usually blank. I have set it to
can shrink in properties, but the report is still showing a blank space for
it. It has no label. Any idea why this may be happening?

 

[Marshall Barton]

I have a report with a field "notes" that is usually blank. I have set it to
can shrink in properties, but the report is still showing a blank space for
it. It has no label. Any idea why this may be happening?

The section containing the text box must also have it's
CanShrink property set to Yes.

The value of the "notes" field must be either a ZLS ("") or
Null, it can not be one or more space characters.

 

[Larry Linson]

I have a report with a field "notes"
that is usually blank. I have set it to
can shrink in properties, but the
report is still showing a blank space for
it. It has no label. Any idea why
this may be happening?

In addition to Marsh's comments, a Control will not "shrink away" if there
are horizontally-adjacent Controls. It must be designed so that the entire
width of the Report will "shrink".

Larry Linson
Microsoft Access MVP

 

[Guest]

That worked - Thanks!!

The section containing the text box must also have it's
CanShrink property set to Yes.

The value of the "notes" field must be either a ZLS ("") or
Null, it can not be one or more space characters.