andrew93
12-13-2005, 08:28 PM
Hello again
I've searched this forum and MrExcel without luck and would appreciate some pointers, if possible.
I'm working with a report in Access 2003 and I want to make an embedded and bound OLE object (i.e. the entity logo) visible or not visible depending on the value of another bound control. In plain English : each entity has a logo loaded in bmp format into an OLE field and each entity also has a 'show logo' option, where 1 = never show the logo, 2 = always show the logo and 3 = only show the logo on e-mailed reports. Both of these items (the logo and show logo option number) are passed through the query and are available to the report. I can't get the logo to appear / disappear on cue so am looking for pointers.
I tried using an IIF statement in the logo control source, like this :
=IIf([Entity_Invoice_Logo_Option]=2,[Entity_Logo],Null)
{NB : Entity_Invoice_Logo_Option is the show logo option number and Entity_Logo is the embedded logo in bmp format. I'm not worried about option 3 yet because I will deal with that later.)
But the logo never appears, irrespective of the value in the Entity_Invoice_Logo_Option field.
I considered using a VBA OnCurrent event as you would with a form (to set the visible property to true or false), but the OnCurrent option is not available under the report events tab. Each entity can and will have differing values in the Entity_Invoice_Logo_Option field so I don't think I should set the visible property of the logo field when I open the report (although I am happy to be proved wrong).
Any pointers as to how I would go about this would be appreciated.
TIA, Andrew
I've searched this forum and MrExcel without luck and would appreciate some pointers, if possible.
I'm working with a report in Access 2003 and I want to make an embedded and bound OLE object (i.e. the entity logo) visible or not visible depending on the value of another bound control. In plain English : each entity has a logo loaded in bmp format into an OLE field and each entity also has a 'show logo' option, where 1 = never show the logo, 2 = always show the logo and 3 = only show the logo on e-mailed reports. Both of these items (the logo and show logo option number) are passed through the query and are available to the report. I can't get the logo to appear / disappear on cue so am looking for pointers.
I tried using an IIF statement in the logo control source, like this :
=IIf([Entity_Invoice_Logo_Option]=2,[Entity_Logo],Null)
{NB : Entity_Invoice_Logo_Option is the show logo option number and Entity_Logo is the embedded logo in bmp format. I'm not worried about option 3 yet because I will deal with that later.)
But the logo never appears, irrespective of the value in the Entity_Invoice_Logo_Option field.
I considered using a VBA OnCurrent event as you would with a form (to set the visible property to true or false), but the OnCurrent option is not available under the report events tab. Each entity can and will have differing values in the Entity_Invoice_Logo_Option field so I don't think I should set the visible property of the logo field when I open the report (although I am happy to be proved wrong).
Any pointers as to how I would go about this would be appreciated.
TIA, Andrew