printing form - BackColor change

[kmeld]

Hi,
I would like to be able to print form with all BackColor properties changed to while.

I do not have any idea on how to go threw all controls on form and change backcolor.

And after printing change them back again.

Could someone advise me on this?

Cris.

[Izandol]

You may use a loop:

Please Login or Register  to view this content.

Do you have to keep different colours for some controls to restore after the printing or will all be the same?

[kmeld]

Thanks.

No I do not need to restore different colours. I restore one standard colour.


It prints ok. But caption of a frame is not printed for some reason. It is visible but not printed.

Do you perhaps know why?

Cris.

[Norie]

Cris

Printing a form doesn't always works out too well, why not transfer the data/images/whatever from the form to a sheet, format the sheet and then print it.

[Izandol]

It has always been so - I do not know why. You must use a separate control such as a label

[kmeld]

Cris

Printing a form doesn't always works out too well, why not transfer the data/images/whatever from the form to a sheet, format the sheet and then print it.

Generally I more would like to save form as pdf. But this moment I only know how to print form from within VBA. And since my project is really focused on other matters, for now printing form is enough.

In some time I will be back with printing issues on this forum.

Cris.