If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
report problems
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 |
#2
|
|||
|
|||
report problems
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 |
Thread Tools | |
Display Modes | |
|
|