Steve Conklin (Developer@UltraDNT)
Developer at UltraDNT.com
Mon Nov 29 22:46:08 CST 2004
Why not in the text box record source, just put an IIF: =IIF([Pages]>1, [Pages], "") Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Monday, November 29, 2004 11:35 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Count pages in a report Ok, I did some research To get count of pages in a report per FMS codetools: Public Property Get CountOfPages() As Integer ' Comments : Returns the count of Pages ' Source : Total Visual SourceBook 2002 ' CountOfPages = m_intCountPages End Property Record source for text box ="Page " & [Page] & " of " & [Pages] Textbox visible = false Pseuodo code If countofpages>1 then textbox1.visible = true where do I put property? How do I write Psudo code and where JOE HECHT LOS ANGELES CA jmhla at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Monday, November 29, 2004 7:51 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Count pages in a report Anyone know how to do it? Working on Purchase orders. If page count > 1 then I want to put page count on all pages. If page count = 1 then no page count needs to be displayed. JOE HECHT LOS ANGELES CA jmhla at earthlink.net -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com