cangrow text beside and under image

  • Thread starter Peg via AccessMonster.com
  • Start date
P

Peg via AccessMonster.com

I am creating a student directory where I have data in canshrink and cangrow
txtboxes next to and under image. The report is a 2-column report, so output
is something like this:

txtbox1 -------------------------- txtbox1
--------------------------
txtbox2 | |
txtbox2 | |
txtbox3 | |
txtbox3 | |
txtbox4 | |
txtbox4 | |
txtbox5 | |
txtbox5 | |
| |
| |
| |
| |
---------------------------
--------------------------
txtbox6
txtbox6
txtbox7
txtbox7


The txtboxes next to the picture will, in most cases, grow past the bottom of
the image.

My problem is that the text under the image is pushed down, leaving a lot of
white space under the image before printing the text. This happens even when
the side txtboxes do not extend past the bottom of the image. I thought it
was caused by the cangrow of the last txtbox next to the image, so I have
tried making that txtbox height to extend past the bottom of the image - did
not resolve problem. I have also tried making all the side txtboxes heights
almost zero - did not resolve problem.

Any suggestions?

Thanks.
 
M

mdullni1 via AccessMonster.com

I guess it doesn't pay to try to draw the picture. I hope you can understand
without the picture. Please ask any questions necessary to help.

Thanks.
 
M

mdullni1 via AccessMonster.com

I figured out how to handle this. The problem was that each cangrow txtbox
pushed the next one down, thus pushing down the txtboxes on the lower rows
under the picture. Access is row-oriented, so it doesn't care if the lower
txtboxes were not under these txtboxes. I created one txtbox where I
concatenated the values from each of the other txtboxes delimited with CRLF
(if value exists). I set this one txtbox height to cover the whole detail
section (i.e. going past the txtboxes under the picture), with cangrow and
canshrink set to yes. I hid the source txtboxes, making height zero and
preventing cangrow. Works like a charm!

Clear as mud??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top