Make box control not visible based on condition

[magmike]

I have created my own tabs using boxes and subforms. However, I would
like one of the "tabs" or the box that makes the tab (as well as the
unassociated label) not visible on the event that a particular field
is empty ([Notes]).

I've played around with this in the OnCurrent event, but have been
unsuccessful. Any ideas?

Thanks in advance!

magmike

 

[Maurice]

You could try setting the control based on the value of the particular field
as follows:

me.tab.visible=not isnull(me.particular field) '-where particular field =
your fieldname

you should also place this in the after update of the field (particular field)

Set the default settings of the tab and box to not visible.

hth

 

[magmike]

You could try setting the control based on the value of the particular field
as follows:

me.tab.visible=not isnull(me.particular field) '-where particular field =
your fieldname

you should also place this in the after update of the field (particular field)

Set the default settings of the tab and box to not visible.

hth
--
Maurice Ausum

I have created my own tabs using boxes and subforms. However, I would
like one of the "tabs" or the box that makes the tab (as well as the
unassociated label) not visible on the event that a particular field
is empty ([Notes]).

I've played around with this in the OnCurrent event, but have been
unsuccessful. Any ideas?

Thanks in advance!

magmike- Hide quoted text -

- Show quoted text -

Perfect, thanks! magmike