Vertical Alignment for text fields in a Report

[KDAnalyst]

I have a report with essentially 4 columns of different text fields (not a columnar report).

As an example, the design looks like this...
[Field1] [Field2] [Field3] [Field4]
[Field5] [Field6]

What I'd like to do is ensure that fields 5 and 6 don't move down based on the content of field 4. This is an example of how the report would look like on preview/print...
[Field1] [Field2] [Field3] [Field4 text wraps around to the 2nd line in this column forcing fields 5 and 6 down a line]

[Field5] [Field6]

Basically, I would like fields 5 and 6 to stay on the 2nd line of the report regardless of the amount of text in other fields to the right. How can I accomplish this?

 

[HGMonaro]

Never encountered the need to do that, however I wonder if you couldn't have two fields on the report [Field7] & [Field8]. [Field7] would be where Field4 is and it's 'control source' would be =LEFT([Field4],40) (or whatever the syntax is) and [Field8] would be on the second line next to [Field6] and would be something like =RIGHT([Field4],40). Those formulas are probably wrong, might need to make them a lot smarter, but something like that! Just tested this and it worked in concept.

[Field8] could be set to 'can grow' so that if it can't handle the length of the string it could extend another line.

 

[stopher]

I think you can just make fields 3 & 4 extend slightly lower. If the bottom of 3 is below the top of 6 then 6 won't move when 3 grows.

hth
chris

 

[HGMonaro]

Chris, yep that works! Will need to remember that just in case!

 

[KDAnalyst]

Thanks for the assistance. I was able to figure it out yesterday (hadn't received any replies), but I think your suggestions would've worked better.

I ended up creating 2 sub-reports as my solution (side-by-side). Next time I roll out an update, I'll revert to suggestion #2 (likely better for application speed I imagine).

Thanks again,
KDAnalyst.