Printing forms, differently coloured pages?

[tomswaelen]

I've created a form which stretches across multiple pages. I've noticed that, when I print the form, the odd pages have a white background (as intended), the even pages have a grey/purplish background (which is not as intended, obviously).

My form will use 2 pages max, but when I stretch the form across 4 pages intentionally, pages 1-3 will have a white background, pages 2-4 are grey.

Does anyone know what causes this and how I can disable it?

 

[pbaldy]

Sounds like the alternate backcolor property is set incorrectly.

 

[tomswaelen]

Sounds like the alternate backcolor property is set incorrectly.

Where do I find this? Bear in mind that I have absolutely no knowledge of VBA code...

 

[vbaInet]

Does anyone know what causes this and how I can disable it?

A form is not really intended for printing. You should be using a report.

 

[tomswaelen]

A form is not really intended for printing. You should be using a report.

I only need to print a specific record, not sets of records. And it needs to be a very specific layout. Can reports be used for that?

Besides the point, anyway.

 

[pbaldy]

Where do I find this? Bear in mind that I have absolutely no knowledge of VBA code...

No code; it's a property of each section, so check whichever section is doing it. I agree about printing a form by the way; I just assumed it was a report. Reports can certainly print a single record. I often use this technique to limit them:

http://www.baldyweb.com/wherecondition.htm

 

[vbaInet]

Yes you can print a specific record. Paul (aka pbaldy) has a link on his site that will allow you to that.

You can copy the controls on your form and paste it on a report.

 

[tomswaelen]

No code; it's a property of each section, so check whichever section is doing it. I agree about printing a form by the way; I just assumed it was a report. Reports can certainly print a single record. I often use this technique to limit them:

I found it, thank you. It was buried deep inside some right-mouse-click windows

 

[pbaldy]

No problemo.

 

[smig]

I only need to print a specific record, not sets of records. And it needs to be a very specific layout. Can reports be used for that?

Besides the point, anyway.

you can save your form as report

 

[vbaInet]

you can save your form as report

Posts #4, #6, and #7 mentions and explains exactly this approach. You didn't read the posts this time

 

[smig]

Posts #4, #6, and #7 mentions and explains exactly this approach. You didn't read the posts this time

I read all posts.
I mean pick the form, use SaveAs... and save as report... No need to copy anything...

 

[vbaInet]

I read all posts.
I mean pick the form, use SaveAs... and save as report... No need to copy anything...

Got ya smig