conditional OLE object

[Steve A]

I have an Access 2000 report for which I want to include a conditional OLE
object (Word text block), and am having a difficult time with it.

In its simplest form, I want to place a field on the report, and based on
that field display a block of text contained in an OLE control. I've placed
two OLE controls on the page, thinking that I could show the control I want
and hide the control I don't.

I created an OnPrint event procedure that should do this. The end result is
the OLE control visibility is set for the first record on the report, but on
subsequent records it doesn't change from what was originally set.

Any ideas would be appreciated...

 

[Terry]

Steve,

This is a long shot (working from a firm base of
ignorance). Try using the section that contains the ole
objects "on format" event to hide/display the objects.

HTH,

Terry

 

[Steve A]

Thanks for the tip, Terry. Your solution worked.

Actually, I tried this originally, but it didn't work, because in my
boneheadedness I set the condition to a value which was right padded with
spaces. I did a trim(value) and all is well with the world!

 

[Terry]

Steve,

Pleased to hear you're making progress,

Terry