Good morning,
Hope everyone is well! It has been a while!
I have a report where I need to be able to show an enormous amount of data.
I store the data on a SQL server, using Access 2013 on the front end.
SQL has all the data (41 pages worth), but the report in Access only shows about 30 pages of the data before the text box starts to scroll. Exporting it to a PDF just truncates the data at the breakpoint.
Is there a way to increase the amount of data a box can display in a report so that it will show all of the data in a field? Or is it limited to the 65,535?
If it is limited, does anyone have a suggestion on how to merge two fields together so that all the data can be displayed?
Off the top of my head, I am thinking I could do a count of characters and when it hits a certain point (65,000), then have the rest displayed in a second box.
Not sure how I would do that, but just throwing an idea out there.
Thanks in advance for any help!
Will
Hope everyone is well! It has been a while!
I have a report where I need to be able to show an enormous amount of data.
I store the data on a SQL server, using Access 2013 on the front end.
SQL has all the data (41 pages worth), but the report in Access only shows about 30 pages of the data before the text box starts to scroll. Exporting it to a PDF just truncates the data at the breakpoint.
Is there a way to increase the amount of data a box can display in a report so that it will show all of the data in a field? Or is it limited to the 65,535?
If it is limited, does anyone have a suggestion on how to merge two fields together so that all the data can be displayed?
Off the top of my head, I am thinking I could do a count of characters and when it hits a certain point (65,000), then have the rest displayed in a second box.
Not sure how I would do that, but just throwing an idea out there.
Thanks in advance for any help!
Will
