hi there.. I want to print a control on a report, based on the criteria of
whether the value in the control is null or not...

My hunch is that I have to manipulate the Visible property.. and I think I
need a criteria that looks something like
Visible = 0 if [RptOneTable]![Prepaid] isnull

but I can't figure out where to put this criteria.. the visible property
seems to only accept yes and no, (0 and -1 I assume)...

I think I'm close but can't quite sort it out..

with thanks
Helen in Canada
--------------
hrmartin (AT) axion (DOT) net Nanaimo, BC Vancouver Island Canada

Set the Can Shrink property of the control to Yes. Then if the control's
value is Null, it will not print on the report.

--

Ken Snell
<MS ACCESS MVP>


"Helen Martin" <hrmartin (AT) nospam (DOT) axion.net> wrote