Set visible objects when opening Report

[Terry]

I'd like to call a report from a form, using a Command button and I'd
like to make an unbound object, OLEBox, not visible in the report
footer.

I've tried:
DoCmd.OpenReport "TrackingRpt", acPreview, , ,OLEBox.visible=False
but get a compile error saying "Variable Not Defined"

Can this be done in the OpenArgs part of OpenReport?

Terry

[paii, Ron]

You can send an argument though OpenArgs, that the OnOpen event will read to
hide the control.

"Terry" <tc*****@merseymail.com> wrote in message
news:38*************************@posting.google.co m...

I'd like to call a report from a form, using a Command button and I'd
like to make an unbound object, OLEBox, not visible in the report
footer.

I've tried:
DoCmd.OpenReport "TrackingRpt", acPreview, , ,OLEBox.visible=False
but get a compile error saying "Variable Not Defined"

Can this be done in the OpenArgs part of OpenReport?

Terry

[Marleen]

Terry,

Although you open the report, the code behind the button continues to run until
it gets to the End Sub line. So all you need to do is put the following code
after the OpenReport line:
Reports!TrackingRpt!OleBox.Visible = False

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Terry" <tc*****@merseymail.com> wrote in message
news:38*************************@posting.google.co m...

I'd like to call a report from a form, using a Command button and I'd
like to make an unbound object, OLEBox, not visible in the report
footer.

I've tried:
DoCmd.OpenReport "TrackingRpt", acPreview, , ,OLEBox.visible=False
but get a compile error saying "Variable Not Defined"

Can this be done in the OpenArgs part of OpenReport?

Terry

[Terry]

Thanks Marleen,

Works like a dream:)

"Marleen" <mm*****@earthlink.net> wrote in message news:<VB*****************@newsread2.news.atl.earth link.net>...

Terry,

Although you open the report, the code behind the button continues to run until
it gets to the End Sub line. So all you need to do is put the following code
after the OpenReport line:
Reports!TrackingRpt!OleBox.Visible = False

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Terry" <tc*****@merseymail.com> wrote in message
news:38*************************@posting.google.co m...

I'd like to call a report from a form, using a Command button and I'd
like to make an unbound object, OLEBox, not visible in the report
footer.

I've tried:
DoCmd.OpenReport "TrackingRpt", acPreview, , ,OLEBox.visible=False
but get a compile error saying "Variable Not Defined"

Can this be done in the OpenArgs part of OpenReport?

Terry

[Ray]

tc*****@merseymail.com (Terry) wrote in message news:<38*************************@posting.google.c om>...

I'd like to call a report from a form, using a Command button and I'd
like to make an unbound object, OLEBox, not visible in the report
footer.

I've tried:
DoCmd.OpenReport "TrackingRpt", acPreview, , ,OLEBox.visible=False
but get a compile error saying "Variable Not Defined"

Can this be done in the OpenArgs part of OpenReport?

Terry

Hello Terry,

I know that your question has been answered by another,
but why not just set the visible property for your object
to NO, then you don't need any code at all?

Regards,

Ray