Print Button prints out a form different from the one showing on the screen

[Form2018]

Print Button prints out a form different from the oneshowing on the screen
I have an input put screen which users use to enter numerousfields of data. The form layout has numerous colors and notes to make sure datais input correctly. When you print the forms it is not designed to fall onto on8.5" 11" page and has color background, and other notes not neededfor the form printout but helpful for the data entry.

I would like to havea print button that prints one form of the data being displayed on the screenbut actually prints the data using a different form without all the backgroundand unnecessary notes and clutter. It would be black and white only and fall nicelyto one page.
I'm very limited withAccess but have done some recorded macros in Excel which has helped me getaround lack of coding skills, maybe that could be done here.Also, I did notcreate the db and was wondering if the developer could easily email the form Ineed to modify so I could help create the plain black & white version ofthe form.


Thanks in advance! j

[RuralGuy]

Forms are not really designed to print but Report are. Could you design a report that does what you want. Calling a Report from a button on a Form is a snap.

[Form2018]

Sure Ruralguy, I can try and create a report if that's the better tool. My developer has resisted my idea, no wonder. Any pointers to get me started, can we use a macro to make it easier? I was hoping to avoid entering all the fields which are in the existing form which was why wanted to use a second version of the existing form. When I think of reports would not normally think of a report only have one record which is all that is needed.

Thanks for you speedy feedback. j

[RuralGuy]

The Report wizard is pretty good and you can easily tell the report what record to look at from the form.

[RuralGuy]

The Report can use the same Record Source as the Form so all of the fields will be available.

[Form2018]

Thanks again RuralGuy, that's good same fields can be used on the form and report. I did have a concern about the report in that how will it know which record to print, is there a 'current record' or such command. I'm always going to want to print just the one showing on the screen.


Regards,

j

[RuralGuy]

And here's the solution to that dilemma: http://www.baldyweb.com/wherecondition.htm
Reports open just like Forms and the wizard know how.

[ssanfu]

Did you know you can save a form as a report??

Still have to do some editing but a lot easier.....

See https://www.techrepublic.com/blog/mi...fore-printing/

[Form2018]

These are great suggestions and thanks also for the links. I'm going to consider this one solved!

Best Regards,

j