Unwanted alterations in spacing

[Guest]

My report is actually an exam based on several tables in my database. Using
some assistance from the more experienced Access professionals in this forum,
I've used conditional formatting to handle a number of different
circumstances for each question. For example, if a question is a part of a
case or stem, the text of that case will appear before the first question in
the series. If the question refers to an image, a message appears before the
question instructing the student to consult the image.

There is no group heading on my report; just a detail section. In that
detail section are text boxes containing Question, Case Text, Directions,
Answer Choices, etc...

Some of the text boxes have control sources set to modules within my VBA
code. For example, txtCaseText control source
"=IIf([Blank_Text]=True,"",[Case Text])"

These have all worked to perform exactly as I want. The unwanted
side-effect of all of this formatting, I think, is that the spacing on my
report widely varies. There is no consistency nor discernible reason for
variation from question to question. On any given page the questions may be
too far apart or too close together. Is there a way that I can set more
consist spacing within the report?

I have taken the advice of Ken Snell and set a blank text box on the bottom
of my detail section that expands (via Chr(13) & Chr(10)) under certain
conditions. As well as this worked when my report followed simpler
formatting rules, it now does not prevent the wide variations in spacing that
I see.

I have more information to offer upon request, including code of my
conditional modules and exact spacing requirements. Thank you in advance for
your time and support.

Best,

Joe

 

[Guest]

If the variations are vertical then set the Can Grow to Yes and size then
down to display one line.