Blank lines - no solution works

[Guest]

I did a search under blanks and tried every solution given here, and nothing
seems to work. I have text boxes (not labels) running down the page like this:

text1
text2
text3
text4

sometimes they are blank, but the blank space still shows up in the report!
They are all set to CanShrink YES, and the section that they are in is also
set to YES. There is nothing on the same horizontal line as these boxes, but
they won't shrink. This is driving me crazy, because it seems like it should
work.

 

[Duane Hookom]

How do you define "blanks"? If the fields are Null, they should shrink. If
they are a space or a zero-length-string, they will not shrink.

Have you tried displaying the text box border so you can determine if the
text boxes are shrinking or not?

 

[John Spencer]

Do the controls overlap by any amount at all?

Are you sure that text is null or a zero length string and not one or more
space characters?

 

[babyatx13 via AccessMonster.com]

Dino,

If you have ANY space at all between your text boxes those spaces will show
and it will appear that the text boxes have not shrunk. Try making all of
your text boxes touch and see if this fixes the problem. If your text boxes
already touch each other please disregard this post.

K Board

 

[Guest]

YES! That worked! Thanks...

Dino,

If you have ANY space at all between your text boxes those spaces will show
and it will appear that the text boxes have not shrunk. Try making all of
your text boxes touch and see if this fixes the problem. If your text boxes
already touch each other please disregard this post.

K Board

 

[Guest]

Well as it turned out, the report was displaying the spaces between the
boxes, not the space that the blank text boxes occupied. Once I took away
those spaces, the spaces were gone.
BUT...the reason I didn't have labels for these text boxes was because I
could not make them shrink either, and I know it's a lot more problematic
when you have labels on the same horizontal line. I tried all of the
solutions for that as well, that were posted here and none worked for me.

For the future, how would I determine if a field is null vs. zero-length or
a space?

 

[Duane Hookom]

You can use the IsNull() function to determine if a field (or variable) is
null.

 

[babyatx13 via AccessMonster.com]

Dino,

You are quite welcome. )

K Board

YES! That worked! Thanks...

Dino,

[quoted text clipped - 18 lines]

 

[Guest]

I know this is a late entry but someone might find it useful!

After scratching my head as to why I couldn't get a blank line to disapear I
switched my machine to work in Inches rather than Centimeters realigned
everything and now the blanks have gone!