print a control based on a criteria

[Helen Martin]

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
--------------
hrma...@axion.net Nanaimo, BC Vancouver Island Canada

[Ken Snell]

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" <hrma...@nospam.axion.net> wrote in message
news:Xns961781E28F08E...@198.80.55.250...