Report Background

[ckugo]

I am needing the background of a certain report to hide before the report gets printed. I have been able to get the background to hide after I print the report but not prior to. Does anyone have any idea on how to go about doing this?

Thanks a lot,

Chris

 

[kjv1611]

Are you using code to do this? If so, try posting your code here..

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[ckugo]

I was just using

report.picture = ""

in the onpage function.

I am farely new to vb coding so I need all the help I can get. If there is any other way of doing this, I would be more than glad to try.

Thanks for your help,

Chris

 

[kjv1611]

Hmm.. haven't tried with backgrounds, but would imagine they would have a visible property.. try changing to this:

report.picture.visible = false

just remember to put

report.picture.visible = true

at some other point for it to show up when you do want it to be viewed.

See if that helps, and post back with errors/progress..

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[ckugo]

Thank you both for your help with this problem. KJV, I tried to find that property but did not have any such luck. I think I have the code to do it, but I just need to fiugre out where to put the code to execute before it prints.

Thanks,

Chris

 

[kjv1611]

Well, you could put the visible = true part in the load or open even of the document, I would guess; and you could put the visible = false part in whatever code calls the print event. For instance, if you have a button that you use to print the document, you could put it in that code. If not, then maybe there is an _OnPrint event or something like that?

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[kjv1611]

Chris, have a look at thread705-920552
It may not be exactly what you're looking for, but it may help you go in the right direction.. the answer mentions something about a "On Print" event something like Form_Print() or cmbCombo1_Print()... I think it'd be worth your time to look at it.


Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV