I have a very particular report request. It is currently being generated from an outside program that I'm attempting to get away from by regenerating it within Access. This program generates text files on the side, and I've been very successful in getting Access to do the database assembly necessary to generate that. That is not a problem for me.
The problem comes from the form this program generates from that very text file's data. It's very particular in setup. From font (Courier New, 11), to characters per line (80), to lines per page (60). My problem arises from trying to generate this report.
Normally, I'd just use fields and manipulate everything, but each page of the 1-3 page report are far too different to set up a template for. My only conclusion was to draw up the report using a table that is generated containing each line for each page used. So, I figured that would be easy enough, using a single field for the line data and just fill in records.
I tried this and came up with a problem: I wasn't able to fit the 60 lines on the page without cutting into certain characters such as g, j, p, and y. Anything that carried into the bottom of the text field would be cut off, and resizing the text field to not do that caused too much space between lines, fitting, at best, 56 of the 60 lines required.
So, I had another idea. I'd make a field in said table for each line, and make a record for each page. This seemed to work quite well. Then I maxed out 48 fields of the 60 needed, and got an error about record length.
I had another thought, of splitting the table up into 6 fields and using a query to assemble it all. So, I condensed the table to 10 fields, made 5 additional copies, linked them into the query, and ran it. Everything popped up fine. No errors in records. Yay!
Then I tried to assemble the report. I get an error about record length again. It is at this point where I come here, totally out of ideas. Perhaps I'm just going about this the wrong way. Is there a proper way to adjust line spacing so one can forceably control the number of lines on a sheet, or is there a better way to do this?
The problem comes from the form this program generates from that very text file's data. It's very particular in setup. From font (Courier New, 11), to characters per line (80), to lines per page (60). My problem arises from trying to generate this report.
Normally, I'd just use fields and manipulate everything, but each page of the 1-3 page report are far too different to set up a template for. My only conclusion was to draw up the report using a table that is generated containing each line for each page used. So, I figured that would be easy enough, using a single field for the line data and just fill in records.
I tried this and came up with a problem: I wasn't able to fit the 60 lines on the page without cutting into certain characters such as g, j, p, and y. Anything that carried into the bottom of the text field would be cut off, and resizing the text field to not do that caused too much space between lines, fitting, at best, 56 of the 60 lines required.
So, I had another idea. I'd make a field in said table for each line, and make a record for each page. This seemed to work quite well. Then I maxed out 48 fields of the 60 needed, and got an error about record length.
I had another thought, of splitting the table up into 6 fields and using a query to assemble it all. So, I condensed the table to 10 fields, made 5 additional copies, linked them into the query, and ran it. Everything popped up fine. No errors in records. Yay!
Then I tried to assemble the report. I get an error about record length again. It is at this point where I come here, totally out of ideas. Perhaps I'm just going about this the wrong way. Is there a proper way to adjust line spacing so one can forceably control the number of lines on a sheet, or is there a better way to do this?
