I'm creating a very simple report in Design view, using only the "Details" section. The height of the entire section is only about 1-2 inches, nice and slender, so I can view many records on a single page easily. There is a textbox small enough to accommodate a single sentence in the aforementioned details view. That size is all that's needed 95% of the time.
Trouble is, every so often a textbox that houses a full paragraph shows up. Naturally, all but the first sentence gets dropped from the Report, because the textbox control is so small.
The only way around this problem that I know is to enlarge the "Details" section height and make the textbox much much bigger, eating up tons of screen real estate with blank area.
Is there a way to make a Textbox control that's small, but increases it's height property automatically if it detects a large chunk of text within it, and more specifically, will that particular row of the report scale automatically to fit these oddball records?
I imagine this can't be too uncommon of a question, I apologize if it has been answered already. Thank you for any input,
Matt