Setting visible in a report? Or?

Hi,

I've got a report that has a subreport on it. On the subreport I've got a
label and control printing.

I'd like to have both the label and the control print only if it's not the
default for the control. The label/control is a lblDrLicNo/DrLicNo.
Default for control is "1111" (string).

I put the routine to make both label and control invisible if DrLicNo =
"1111" into the OnActivate in the subform and just running the subform, it
works fine. But as soon as I run the main form with the subform within it,
it prints the label and control regardless of what the control has in it.

How can I get done what I want?

TIA
ron

"Ron" <ronSPAMBLOCKERwest777@earthlink.comwrote in
news:eMvug.714$157.159@newsread3.news.pas.earthlin k.net:
First, read http://www.mvps.org/access/forms/frm0031.htm

Second, I think you might be better to use the OnFormat Event of
the subreport as the location for your code.



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

"Bob Quintal" <rquintal@sPAmpatico.cawrote in message
news:Xns9802A039BEB82BQuintal@66.150.105.47...This NG is fantastic!

Yup, the OnFormat Event did the trick. Thanks!

And thanks for the link to that chart too--I'll be using it regularly.

Hang in
ron