Hide a subreport and a check box

[John B]

Hello to everybody.
I would like to hide a subreport when it has no data to show and hide a
checkbox when the value is No.

It is possible?
Many Thanks for your help
Regards
John B

 

[Allen Browne]

A subreport with no data will automatically disappear.

To show only the check mark for yes, with no empty box for no, use a text
box instead of a check box. Set these properties for the text box:
Control Source {Name of your yes/no field here}
Font Name Wingdings
Format ;\ü
To type the 3rd character for the Format property, hold down the Alt key and
type 0252.

The trick works, because Access uses -1 for True, and 0 for False. The
format says to use nothing for positive numbers (nothing before the
semicolon), and then the literal character (hence the backslash) 0252. In
the Wingdings font, that's a check mark. Use 0254 if you want a check mark
with a box around it.

 

[John B]

Thanks for the tip.
Regards
John B

 

[Michael N]

Allen,

I knopw that a subreort does not appear when there is no
data, but is there a way for the sectiopn of the report to
close up the space that is left blank by the non existatn
report?

if on 09/13/2004 there is no data for the subreport on
that day, can the group date header area shrink to take up
the space that is not being used on the report output.

Mike

 

[Allen Browne]

Sure.

Set the CanShrink property of the subreport to Yes.
Make sure the CanShrink of the group header section is also Yes.
Make sure no other controls overlap the subreport verticaly.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,

I knopw that a subreort does not appear when there is no
data, but is there a way for the sectiopn of the report to
close up the space that is left blank by the non existatn
report?

if on 09/13/2004 there is no data for the subreport on
that day, can the group date header area shrink to take up
the space that is not being used on the report output.

Mike