Can Shrink Field Still Showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
smboyd said:
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?
Click to expand...


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.
 
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?
Click to expand...

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
 
That worked - Thanks!!

Marshall Barton said:
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.
Click to expand...
 
Back
Top