Unwanted Blank Spaces

[Guest]

I have some a textbox called age in the detail section of my
report.Unfortunately there are blank spaces after each value that is printed
for instance
Age
45

43

78
I would like it to appear as
45
43
78
I have tried the CanShrink Property as Well as RTrim ,trim and LTrim but
this problem is not going away could you please help me out.The spacing is
one line approximately.

Thanking you in advance.

 

[Ken Snell [MVP]]

Are you displaying multiple instances of the textbox, with one number in
each instance? Or are you concatenating all the ages together into one
textbox?

Did you set the CanShrink property of the Detail section to Yes as well?

Are there other controls to left or right of this textbox? Are any of these
controls labels? Tell us a few more details.

 

[OfficeDev18 via AccessMonster.com]

What appears on the report is not only the contents of the text box, but also
the contents of the entire detail section, as well as any footer following
the detail section.

For instance, say your text box is 1/4" high, and your detail section is 1"
high. The entire 1" will print every time the detail section is printed;
setting your text box's properties will not affect this. You have to manually
adjust the detail section so it's the height you want to display (usually a
bit larger than the text boxes in the section).

Also, if there's a footer section below the detail section, and the footer is
blank (no text boxes), the detail section may be displaying as well. You can
remove a footer section by clicking on the Sorting and Grouping icon in the
menu and removing the appropriate footer.

 

[Guest]

Thank you for the reply.Yes I am mulitple instances of the textbox.I am not
concatenating the ages.Yes I have set the detail's section canShrink to
yes.The control is aligned left that is how I would like it to appear.The
word age is a label
and the actual values themselves are in a textbox.