Need to create a blank report

[Michael Auer]

Hello.
I need to create a report that will be printed and used as a paper form on which people will enter information to eventually be transferred to my database. The source will be a table, and the report will need to show all fields from the table, even when more fields are added to the table. If new fields are added to the table, I will add the necessary text boxes or whatever to update the report. I would like to add a button to the Access form where the data is entered to print the report, but with all fields blank. Any ideas?
Mike

 

[Uncle Gizmo]

show all fields from the table, even when more fields are added to the table

I think this is a nonstarter, although it would be possible, and you may be lucky enough to find some code somewhere that would do it. However reports are difficult enough to plan and manage, doing them yourself! So I wouldn,t hold out much hope of reports created from code looking very good, unless they were just simple ones like you can already do with the report wizard.

 

[Uncle Gizmo]

print the report, but with all fields blank

Base your report on a query, specify a criteria for the query that will never be true . For example if you have an auto number field, they usually start at one and increment upwards. Therefore they are unlikely to hold minus values Specify a criteria on the ID field to return records where the ID is less than zero.

This should return "no records" and you're report will be empty.

 

[Michael Auer]

Thanks, Uncle Gizmo.
I'll give that a try. The other thing I thought of is to change the font color to white in the text boxes, etc. I like your idea better though.
Mike