In the format event of the section containing the control use VBA like the
following

IF Me.[Total In Stock]- Me.[reorderlevel]=0 then
Me.ShowTotalControl.Visible = True
ELSE
Me.ShowTotalControl.Visible = False
END IF


Or you could try conditional formatting and setting the font color to match
the paper color. White on White is pretty well invisible.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"pigsy101" wrote in message
oups.com...
i have a check box whose control source is:

=[Total In Stock]-[reorderlevel]=0


how can i set the control to only be visible if this check box is
true?


tried macro and vba, but can't quite work it out.


thanks in advance


Paul