Controlling Object properties in report

[e34m5]

I am trying to control the visibility property of an object based on it's value.

The name of the object is MyObject (unbound text field). The field that controls it's visibility is a logical and it's named [Enabled].

In the control source of [MyObject] I placed the following expression:

=iif([Enabled], [MyObject].visible = True, [MyObject].visible = False]

This is not working. I tried manipulating several different properties such as color and border and in either case nothing happens.

[Rabbit]

I am trying to control the visibility property of an object based on it's value.

The name of the object is MyObject (unbound text field). The field that controls it's visibility is a logical and it's named [Enabled].

In the control source of [MyObject] I placed the following expression:

=iif([Enabled], [MyObject].visible = True, [MyObject].visible = False]

This is not working. I tried manipulating several different properties such as color and border and in either case nothing happens.

I don't think you can do it in an expression. You'll need to do it through the code builder, most likely in the On Render event.

[e34m5]

No such event in a report. I am really hating Access. I have never had such issues in other development languages.

[Rabbit]

No such event in a report. I am really hating Access. I have never had such issues in other development languages.

Try the on open event then. I could've sworn there was an On Render event.

[e34m5]

Nope.

Nothing in VB seems to follow standard dot notation.

[Rabbit]

Nope.

Nothing in VB seems to follow standard dot notation.

What code did you use? Can you post it here?

[nico5038]

Try the OnFormat event of the detail(?) section holding the control like:

IF Me![Enabled] then
 Me![MyObject].visible = True
else
 [MyObject].visible = False
endif
 

Nic;o)