Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Code to print a BLANK form

Status
Not open for further replies.

dab1477

Technical User
Mar 4, 2011
33
US
I created a form to collect responses from a process audit. I would like to print a blank form - having all the labels and blank input fields (checkboxes). Presently, I can print a completed form, but this had detail on it from a previous audit. Not what I want.

Any ideas how to do this? Not sure I need code, but I simply can't print a blank form - only a record will print.

Thanks.
dab1477
 

What application? Is it a UserForm? If so, could you assign blanks to text boxes and labels, un-check the check boxes, etc. before you print the 'blank' form?

Have fun.

---- Andy
 
Access 2010. I've tried removing data and printing, unsuccessfully
 
Is the form bound ?
Did you try to print the form when in insert mode (ie new record) ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
The form is an input form for a table. I have tried to print at "insert", but it prints out a completed form - not a blank; even when the form on the screen is blank - I get a record.
 


Why not a Prnt Scrn?

Crop in Paint Brush or Photo Shop.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Thanks everyone. I ended up outputting a record to .PDF and then photoshop out the detail I did not want. I was able to save and use as a template. Not quite what I wanted, but the work-around will do.

Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top