Charlotte Foust
cfoust at infostatsystems.com
Wed Nov 19 17:46:15 CST 2003
Put it in the main report and set the pagebreak to Visible = the subreport's HasData property. Charlotte Foust -----Original Message----- From: Susan Geller [mailto:sgeller at cce.umn.edu] Sent: Wednesday, November 19, 2003 2:31 PM To: accessd at databaseadvisors.com Subject: [AccessD] Page Break and SubReport I have a report that has a subreport. In the subreport there sometimes is data and sometimes not. When there is data, I want a page break and then the subreport. When there is not data, I want no page break and no subreport. When I put the pagebreak in the main report, I get a page break regardless of what's in the subreport. When I put it in the subreport, I still get a page break even when the subreport doesn't show because there is no data. I've tried a couple of code manipulations that look to see if there is no data and if there isn't set the subreport to invisible, but that doesn't work. Suggestions? --Susan Susan B. Geller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com