UNWANTED BLANK SPACES

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

Guest

Hallo everybody
I had made a post about this question.But the solutions offered did not help
me.Once more
There are blank spaces for instance
Age <---------------label called lblAge
45 <--value from Age textbox

46 <--value from Age textbox

67 <--value from Age textbox
Should be
Age
45
46
67
I have set the CanShrink of all the sections to No and for the textbox.But
it has had no effect.I have also used the Trim function but it doesn not
work.If there a way using code to get rid of the blanks.I have also got rid
of the footer sections.I am not worried about the alignment of the data.
 
Are there ever cases in which the gaps do not appear? If there are text
boxes to the right or left of the ones in question, and if those text boxes
grow, they will create the gaps you mention. Is this a single record or
multiple records? If it is a single record you can concatenate the fields.
One way is to base the report on a query, and to add a field: AgeList:
[Age1] & chr(13) & chr(10) & [Age2] & chr(13) & chr(10) & [Age3]. Chr(13)
is line feed (skip to the next line) and chr(10) is the quaintly named
carriage return (go all the way to the left). I think I have that correct.
In any case, they need to be in that order. Then all you need to do is bind
a text box to that field, with the text box's Can Grow property set to Yes.
 
Obvious question - please don't be offended, but
how high is the detail section? Is it the same height as the Age textbox?
 
Back
Top