Any suggestions on how to create a form/report (will be printed) that has a LOT of text mixed in with data? Is this something that can be handles with an MS Word merge of some sort, or because of the complexity would it be better handled within ACCESS 2002.
I have no problem with the coding, I'm looking more for ideas on how to design overall.
The text content will not change frequently (could be placed in a table??), and a single piece of text may be used in more than one form/report.
In some areas, the text content will be about 1/2 a printed page in length (as opposed to just a line or two).
For many of the printouts, there is actually very little data - it's mostly text. Many will have NO calculations at all.
Thanks in advance!!!
Example of how a piece of report would look:
...title, etc
1) This is a text paragraph that goes on for 2 or 3 lines and will wrap.
2) Second text pararaph that needs to include FIELD1-DATA in the middle of a sentence.
3) Third text paragraph that goes on for 2 or 3 lines and will wrap.
FIELD2-DATA FIELD3-DATA
...page footers with page#, print date, report ID, etc.
I have no problem with the coding, I'm looking more for ideas on how to design overall.
The text content will not change frequently (could be placed in a table??), and a single piece of text may be used in more than one form/report.
In some areas, the text content will be about 1/2 a printed page in length (as opposed to just a line or two).
For many of the printouts, there is actually very little data - it's mostly text. Many will have NO calculations at all.
Thanks in advance!!!
Example of how a piece of report would look:
...title, etc
1) This is a text paragraph that goes on for 2 or 3 lines and will wrap.
2) Second text pararaph that needs to include FIELD1-DATA in the middle of a sentence.
3) Third text paragraph that goes on for 2 or 3 lines and will wrap.
FIELD2-DATA FIELD3-DATA
...page footers with page#, print date, report ID, etc.
