hiding label text

[yoavchen]

i want to make a condition that if an OLE object of mine is empty then the label won't be visible. (visible=no)

The reason i want it is that the ;label is placed inside the OLE object frame, and when i fill the ole object i want that the label will disappear

 

[maxmangion]

try this:

if isNull (me.olename) then
me.label.visible = false
else
me.label.visible = true
end if

replace olename and label, with the actual names of your ole object and label.

 

[yoavchen]

i did what you told me to, i put this code in the After update of the OLE object and it is not working.

 

[mwn1218]

If tried this putting the code in the afterupadte event of a combo box. So once i selected a record then it check to see it was null. I tried this for a text box and not an ole object so hopefully it will work you.

if Not isNull (me.olename) then
me.label.visible = false
else
me.label.visible = true
end if