Expand my Community achievements bar.

Is there a way to contain an expanding table so that it does NOT overflow?

Avatar

Level 2

I have a table within a positioned subform and if there are more rows in the table than space in the subform, the data overflows past the boundaries of the subform.  I want the data to be cut off at the boundary, such as how you can select for a field to "Limit Length to Visible Area" so that the text in the field doesn't go past the field size.  I don't even want it to flow to another page, just cut it off so that it doesn't print over other fields that are below the subform on the page.  Anyone know how to do this?

4 Replies

Avatar

Level 3


Hi AncientGrams,

I am a bit confused with your question, would you like to restrict the cell getting expanding or the table itself? If table, then you can restrict the number of repetitions and if it's the cell that you want to restrict displaying text more than it's width then you can limit the cell in that particular row to "visible area". Also, you can try setting the cell to allow multiple lines so it doesn't cut the data but wraps the text on to the next line.

Avatar

Level 2

Neither.  I want the table to expand, but not past the boundaries of its 'container.'  By container I just mean the subform that it's wrapped in that I set to be a certain height on the form.  The table itself I cannot limit by row count because I don't know how many rows it will take to fill up the space I set for the subform, because cells are expandable.  Therefore any single row may take up only 1 line, or 10 lines if there is a lot of text in it.  If all the rows were only 1 line, of course I could easily limit my table to N rows, but since I don't know how many lines any particular row will take up, I can't do that.

Avatar

Level 2

I am desperate to know this as well.  I have one cell in a 1x6 table set to expand to fit height-wise.  But I don't want the whole table to expand beyond the border of it's area.  Anyone figure out how to constrain a table within a subform?

Avatar

Level 3

Sorry, I haven't been logging into forums due to work pressure. Did you find a solution for this issue?