What I have:
My employer has several paper-based forms that we use daily. These forms are standardized and thus cannot be changed. Many of these forms are 'spreadsheet style' forms in which employees fill in the boxes by hand, enter into my db, then file the handwritten copy for the record.
What I am trying to do:
I would like to incorporate these forms within Access, as the vast majority of the paper records we have are unreadable -- some due to age, others due to it appearing as though the person filling it out was having a seizure as they wrote.
The problem:
Creating the header, footer, and 'grid' surrounding the records in the Access form is the easy part. It is filling in the space between the bottom of the last record and the top of the footer with blank 'cells' (for lack of a better term) that is causing me to want to suck-start a shotgun. If I successfully incorporate these forms, they will be printed multiple times daily by many different individuals, each with different number of records based on different criterion, so adding 'blank' records to fill the report is not a viable option (I tried...wound up with about 500 blank records in my table by the end of the day).
Any help would be greatly appreciated. Thank you in advance for your time. Have a good day.