OLE Bound Control

[Brian Keanie]

I had asked a question about the above subject a few days ago and between
Stephen Lebans and Rog received the following answer.
Would someone please tell this *Air Head* ....
1 What is meant by Air Code
2) Where and how do i use this valuable info you gave me. Seriously.
Thanks again.

Test for existance of image data, if NULL set the OLE Frame control's
VISIBLE prop to NO.
*Air Code*
Me.NameOfYourOL EFrameControl.V isible = NOT
(IsNull(Me.Name OfYourOLEFrameC ontrol.Value))

[Stephen Lebans]

Re: OLE Bound Control

For a report you would place the code in the Format event of the section
containing the bound OLE Frame control.

--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Brian Keanie" <bkfibrex@sympa tico.ca> wrote in message
news:sY0Wd.4691 8$kz6.853280@ne ws20.bellglobal .com...[color=blue]
> I had asked a question about the above subject a few days ago and[/color]
between[color=blue]
> Stephen Lebans and Rog received the following answer.
> Would someone please tell this *Air Head* ....
> 1 What is meant by Air Code
> 2) Where and how do i use this valuable info you gave me. Seriously.
> Thanks again.
>
> Test for existance of image data, if NULL set the OLE Frame control's
> VISIBLE prop to NO.
> *Air Code*
> Me.NameOfYourOL EFrameControl.V isible = NOT
> (IsNull(Me.Name OfYourOLEFrameC ontrol.Value))
>
>
>[/color]

[Brian Keanie]

Re: OLE Bound Control

Sorry still don't get it. I assume the Format event can be seen within the
property window. I don't see that for my OLE object but can see the
oppotunity in a text box . Sorry but would love to get this right.

"Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot com@linvalid.co m>
wrote in message news:mg4Wd.1389 1$oh4.493657@ur sa-nb00s0.nbnet.nb .ca...[color=blue]
> For a report you would place the code in the Format event of the section
> containing the bound OLE Frame control.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Brian Keanie" <bkfibrex@sympa tico.ca> wrote in message
> news:sY0Wd.4691 8$kz6.853280@ne ws20.bellglobal .com...[color=green]
> > I had asked a question about the above subject a few days ago and[/color]
> between[color=green]
> > Stephen Lebans and Rog received the following answer.
> > Would someone please tell this *Air Head* ....
> > 1 What is meant by Air Code
> > 2) Where and how do i use this valuable info you gave me. Seriously.
> > Thanks again.
> >
> > Test for existance of image data, if NULL set the OLE Frame control's
> > VISIBLE prop to NO.
> > *Air Code*
> > Me.NameOfYourOL EFrameControl.V isible = NOT
> > (IsNull(Me.Name OfYourOLEFrameC ontrol.Value))
> >
> >
> >[/color]
>[/color]

[Stephen Lebans]

Re: OLE Bound Control

The Format event of the Section the bound OLE Frame control resides in
not the control itself!


For example it the OLE Frame control is in the Detail section.

Open the Report in Design view
Double Click anywhere on a blank area in the Detail Section. A
properties window pops up for the Detail section.
Click on the Event TAB
Click in the On Format TextBox control. A small Arrow/CheckMark will
appear in the RIght hand corner of this TextBox. Click on it and select
the only option available "Event Procedure"
Now click on the small Button with the ellipse on it(3 periods ...)

You are now in the VB IDE. THe cursor is in the Detail_Format Sub. Add
the code here.
--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Brian Keanie" <bkfibrex@sympa tico.ca> wrote in message
news:3x8Wd.5085 3$kz6.917134@ne ws20.bellglobal .com...[color=blue]
> Sorry still don't get it. I assume the Format event can be seen within[/color]
the[color=blue]
> property window. I don't see that for my OLE object but can see the
> oppotunity in a text box . Sorry but would love to get this right.
>
> "Stephen Lebans"[/color]
<ForEmailGotoMy .WebSite.-WWWdotlebansdot com@linvalid.co m>[color=blue]
> wrote in message[/color]
news:mg4Wd.1389 1$oh4.493657@ur sa-nb00s0.nbnet.nb .ca...[color=blue][color=green]
> > For a report you would place the code in the Format event of the[/color][/color]
section[color=blue][color=green]
> > containing the bound OLE Frame control.
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "Brian Keanie" <bkfibrex@sympa tico.ca> wrote in message
> > news:sY0Wd.4691 8$kz6.853280@ne ws20.bellglobal .com...[color=darkred]
> > > I had asked a question about the above subject a few days ago and[/color]
> > between[color=darkred]
> > > Stephen Lebans and Rog received the following answer.
> > > Would someone please tell this *Air Head* ....
> > > 1 What is meant by Air Code
> > > 2) Where and how do i use this valuable info you gave me.[/color][/color][/color]
Seriously.[color=blue][color=green][color=darkred]
> > > Thanks again.
> > >
> > > Test for existance of image data, if NULL set the OLE Frame[/color][/color][/color]
control's[color=blue][color=green][color=darkred]
> > > VISIBLE prop to NO.
> > > *Air Code*
> > > Me.NameOfYourOL EFrameControl.V isible = NOT
> > > (IsNull(Me.Name OfYourOLEFrameC ontrol.Value))
> > >
> > >
> > >[/color]
> >[/color]
>
>[/color]