I have a database that is holding records that have a lot of fields. Want to be able to output a report based on a single record. The record has both fields and pictures. I am pulling the record source from the currently open data entry form and using the fields in there to populate the report. The problem is the report gets to a certain length (around 22") and then I can't add anymore controls to it. OK, I can add them, but not without overlapping something else. In other words the report can only be so long. Is there a way around this? I can't be the only one that needs this.
My intent is to enter all the data for a particular record and then print to a pdf the report that would go to the end customer.