Setting visible in a report? Or?

[Ron]

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

[Bob Quintal]

"Ron" <ro*******************@earthlink.comwrote in
news:eM***************@newsread3.news.pas.earthlin k.net:

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

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

[Ron]

"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn**********************@66.150.105.47...

"Ron" <ro*******************@earthlink.comwrote in
news:eM***************@newsread3.news.pas.earthlin k.net:

>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

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

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