Forms Print Problems

[GailQ]

I have a database that was created in Access 2000. I opened/converted it in Access 2010 and I am having problems printing some of my forms showing the borders. In the old format all forms printed with the borders showing. In the 2010 format, only some of the forms print with the borders showing and others have all the data but no borders although they are visible in print view. I checked and compared the properties of the forms that show the borders with those that don't show the borders and can't see any differences.

Just wondering if anyone else has seen this problem before and knows how to get the borders to show in all forms.

 

[vbaInet]

Perhaps you need to change the BorderWidth from Hairline to 1pt or 2 pt.

 

[boblarson]

1. Printing forms is hit/miss at best. They are not designed for printing.
2. Reports are designed for printing.
3. Sometimes, as vbaInet has said, you can't use the default of HAIRLINE because it just has issues with some print drivers. It is best to at least set your lines to be 1pt.

 

[vbaInet]

Forms?? It didn't even click. Whenever I see the word "print" I always assume they are talking about Reports hehe!

 

[GailQ]

Thanks folks. I just went and changed the border width from hairline to 1 pt as suggested and still no printed borders.

The weird thing is that the other 15 or so forms will print the borders and there are no differences in the properties that I can see between the forms that will print the borders and the ones that won't. Never had an issue with printing these forms before converting to 2010.

 

[vbaInet]

Perhaps MS is clamping down on printing of forms. If you convert your form to a report, it should print alright.

 

[boblarson]

It can also do with the placement of your objects and sizing of the forms. Not sure what it looks like and what it should look like (if you wanted to post a couple of screenshots you could - just zip them up into a zip file and then you can upload even though you don't have 10 posts).

 

[GailQ]

Bob, I think that may be my problem. I can see a line under the form that also seems to be at the top when I print the form using Access 2000. It also shows up in Access 2010 in print preview. Also when I print this form in either application, I get a message saying section width is greater than page width and it always prints a 2nd blank page. But I can't see it in design view so I can't remove it. I tried to attach a zipped jpg of the form and you can see the "line" under the comment box at the end. How do I get to remove this line in design view if I can't see it there?

 

[boblarson]

In the properties dialog you can select the objects from the drop down. One at a time, select each LINE object (Line23, Line40, etc.) and see where they appear on the form. If you see the little black squares that show it selected but can't see it, or can't easily see it, that is probably what you're looking for. You can select from that drop down and then hit your delete key to delete it.

 

[GailQ]

I don't have any "line" objects. I did check all the text and label boxes properties and other objects too but it's not highlighting those 2 lines at the top and bottom. There has to be something I'm missing so I'll keep plugging away at it. I think those lines or boxes or whatever it is may be causing the problem since those are the forms that won't print my border lines. So I thank you for pointing me in the right direction and I'll let you know if I figure it out. Tips always welcome!

 

[boblarson]

If you can post a copy of the database (You can do it with less than 10 posts if you first run compact and repair and then right click on the file and select SEND TO > COMPRESSED FOLDER and then upload that zipped file). If you do, remember to include only fake data and also let us know which objects to look at (what report name, etc.).