I need help with expandable controls

[perlfan]

Hi there,

in my report I would like to integrate a calculation table that only appears in certain cases. I thought the option of making text fields expandable is a nice solution. Now I did place several text fields next to each other (see attached image). When I run the report Access places every text field in a new row (see attached image). So even though they are placed in one row in design view they are unsorted in report view. I also tried stacked layout but it didn't work. How come that Access ignores the layout of the report?
Thanks for help.... FRANK

 

[MarkK]

Access is not ignoring your layout. If the report behaved as you suggest, growing controls would then cover controls placed below them.

The problem is that you supply so many empty fields in your record source.

 

[perlfan]

It's definitely not a problem of empty fields. All those fields that you see in the design view are all filled with data. The emtpy space on the report is really just empty space. So every field gets its own row, instead of placing the filled fields next to each other as requrested by my layout..... :-/

 

[MarkK]

In design mode it looks like you have 6 rows of controls scrunched down to zero height with the CanGrow property set to true. Is that right? So un-scrunch them. Set their Height to something more so that they don't have to Grow, and see if that makes a difference.

But the bigger problem: It looks like Perfect Match AND Kontext Match AND Weiderholungen AND the rest of them are all in the same row in the RecordSource. That looks like a data design problem that is causing a report design problem.

This should be one row in your record source . . .

Perfect Match, 75%, 1, 85-94, 40%, 7

. . . and then it would occupy one detail section in your report, and that would, I think, make your life way easier.

Database Normalization???

Hope this helps,