"Can Shrink" Problem

[Guest]

I am using the "can shrink" property to remove unneeded lines in a report.
HOWEVER, it is only partially working. If there are 2 adjacent blank lines
it will only take out 1 of them.

Whats wrong? How do i fix this?

thanx,
Brad

 

[Arvin Meyer]

CanShrink doesn't remove objects like lines, it removes space if the lines
aren't visible. I your code, set the Visible property of both lines to False
and the space will disappear as long as there are no other objects to stop
the shrink.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

1. I realize it only removes the space where blank lines occur.

2. Setting the "visible option" to false on the text boxes will make them
disappear completly. This is not what i want to have happen.

3. Again, why won't the "can shrink" property remove the space left over by
2 adjancent blank text boxes?

 

[Arvin Meyer]

1. I realize it only removes the space where blank lines occur.

2. Setting the "visible option" to false on the text boxes will make them
disappear completly. This is not what i want to have happen.

3. Again, why won't the "can shrink" property remove the space left over by
2 adjancent blank text boxes?

Are there labels marking the text boxes? Are they associated (stuck) to the
text box? Are the text boxes truly empty, i.e. not even a space in one?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Van T. Dinh]

I am not sure from your description but:

i. Beware that if the 2 TextBoxes are empty and "CanShrink" Property is set
to True for both, the 2 TextBoxes will shrink but _not_ the vertical
spacing between the 2 Textboxes you assigned in the DesignView for clarity /
separation between the 2 Textboxes.

ii. The "CanShrink" Property may not work correctly if the TextBoxes (or
other Controls) are placed side-by-side (horizontally). I think this is
mentioned in some of the books I read as well as the Microsoft Knowledge
Base.

iii. If what you observed is actually one of the TextBoxes doesn't shrink
down to the minimum size possible (I guess you can set the border to be
visible for testing) then you need to check to make sure the value doesn't
contain vbCrLf at the end. I don't think Access can shrink this.

Try also the Trim() function in your values to make sure that they don't
contain starting or trailing white spaces.