If you do not have any data you can always enter a "space" and the border will appear.
You can not automatically handle text to auto size up if one of the records have more data. Better then to have a font that is same size for all characters and only show say max 30 first characters with Left( Field ; 30 ) function
Thanks Johan, the "space" suggestion works.
As for the auto-sizing the borders, my goal is to make all of the fields in the row as tall as the tallest field. Is there a way to determine the height of a field in a layout through a calculation? Or, maybe, to determine how many rows of text a field takes up in a layout.
For that you need a font like Courier where every character have the same size and height
Please set answer as helpful or correct answer so that other users with same problem easily can find the answer
1 of 1 people found this helpful
Justin, the solution is not to use field borders.
1. Set all your fields to the same height in the body. still resizing to enclosing parts.
2. Use vertical lines that are slightly longer than the height of your body running into the next part (footer etc.)
3. Make the lines to also be resizing
Then you are effectively creating a box around each field by using lines. Because the lines extend to the next section, each record will have the lines connected to each other.
fo horizontal lines, define the upper and lower borders of the Body.
It is a little tricky, so you need to play with it until it comes out the way you want it.
Thanks Pragmystic, that worked!