I am trying to set up a complicated access report to reflect the contents of an official application form. The fields in the database hold the entries that need to go into the official application form/access report. As such the generated report needs to reflect a certain format and contain box/field outlines for all the fields even if the fields in particular linked sub-tables don't contain data. i.e. there will sometimes be applications which require data to be held in every field and every table for some applications, and others aren't as complicated and maybe only half the tables will hold data related to the main record. However, in all cases I want the report to print out all the possible fields and their borders so that the application form looks complete. I have quite a number of sub-reports in the full report and any solution will need to work across all these too.
I have been looking on line and can find much about suppressing the appearance of fields and sub-reports which don't contain data, but hardly anything that deals with getting access to include areas which legitimately don't contain data, but which need to be seen as empty fields on the final outputs. Is it possible to do this please? I hope this makes sense as a question.
(NB. In terms of expertise - I can just about handle a macro, but can't write my own Access basic for event procedures - though I could edit something someone else has written to change field names etc.)