Printing form problems

[data808]

Why is that whenever I print current form it prints out two borders? One across the top of the page and one on the left side of the page from top to bottom.



Also, why is that where ever I have field boxes to type in on my form, when I print it, it prints a thin outline of the box. I just want it to print the text that is typed into the box.

Any help is appreciated. Thanks.

[Evilferret]

Objects in your form have a property called Border Style

By default on most (All?) newly created objects, Border Style is set to solid with a border width of 1pt. This will make a box around the object.

To shut off the border, right click on the object and select Properties from the dropdown list. The properties sheet will be displayed on the right-hand side of the screen. Then modify the Border Style property, changing it to Transparent.


If you want the border displayed during data input, but not in printing it's a bit more complicated. You'll probably need to add a print button to the form, then add some VBA code to set the .BorderStyle property on the objects when the button is clicked (Before printing) followed by setting it back after printing has completed.

[Missinglinq]

...If you want the border displayed during data input, but not in printing it's a bit more complicated...

And it's a little more complicated because Forms are not intended to be printed! That's what Reports are for!

Linq ;0)>

[data808]

Interesting. Well to answer the first post, i dont really want the border even before i print. So if there is a way to get rid of it all together, how would you do that?

Then to answer this post below, how do reports work? And how would i get a report to generate after I've entered all my data into a form so i can print this report?

And it's a little more complicated because Forms are not intended to be printed! That's what Reports are for!

Linq ;0)>

[Evilferret]

To get rid of the border entirely, just follow the instructions I posted above:

To shut off the border, right click on the object and select Properties from the dropdown list. The properties sheet will be displayed on the right-hand side of the screen. Then modify the Border Style property, changing it to Transparent.

(See image in my original post)

Reports are read-only and are designed for displaying/printing your data. There's a lot to learn - More than I care to put into this post, but here's a basic tutorial to get you started:
http://www.gcflearnfree.org/access2010/10.2

[Missinglinq]

...how would i get a report to generate after I've entered all my data into a form so i can print this report?

Simplest way would be using the Report Wizard. On the Ribbon click on 'Create' and then 'Report Wizard.' The Wizard will walk you through the process.

Linq ;0)>

[ssanfu]

And how would i get a report to generate after I've entered all my data into a form so i can print this report?

One concept to remember is: tables store data. Forms and reports are just objects (methods) to view the data. No data is stored in forms or reports.


You can make a report look just like your form, and using the same query, return the same data.