要怎样才能把ACCESS REPORT在最后一面时候才出现我要的资料<>已经做好了^_^-v

程家伟

有什么或者要如何的ＣＯＤＩＮＧ每当我的最后一面ＲＥＰＯＲＴ时候，我要的资料才跑出来。。。

我想到的ＬＯＧＩＣ是

Private Sub Page Footer_Format(Cancel As Integer, FormatCount As Integer)

   If page++ = null Then Me![myword].Visible = false _
  end if

End Sub

请各位大大帮帮忙了

[ 本帖最后由 程家伟 于 16-9-2006 09:31 AM 编辑 ]

程家伟

我这个的links是不是我要的？

http://www.mcse.ms/post6480165.html

各位大大。。请看看。。不然我就要收拾兼离开了


The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of  the last page.   
Make your report as you normally would with the Page Footer and Report  Footer.   
Make sure there is a control set to = [Page] & " of " & [Pages] in t  he  Page Footer.   
Then for each control you wish to display on the final page footer,  place an unbound control where it should display.
Set each of these controls Visible properties to No.  (Do not disturb the controls you want to normally display at the  bottom of each page.   
Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then  
[PageFooterControlName1] = [ReportFooterControlName1]  
[PageFooterControlName1].Visible = True  
' Do the same for each other ReportFooter control you wish to show  in the Page Footer.
End If   

If you have other controls in the page footer that you do not wish to  display on the final page, set them to Not Visible in the Page Footer  event.   
You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular  page footer controls and turn Visible properties on and off as  required.   

Next code the Report Footer's Format event:  Cancel = True      
Then code the Report Header Format event:    [PageFooterControlName1].Visible = False  
' Do the same for each other ReportFooter control you wish to show  in the Page Footer.      

The Report Footer information should display at the bottom of the  report where the Page footer normally does.

--  Fred  Please respond only to this newsgroup.  I do not reply to personal e-mail

[ 本帖最后由 程家伟 于 15-9-2006 05:19 PM 编辑 ]

程家伟

I have a text box that I only want visible on the last page of the report.
I
> am working in Access 97. Does anybody know how to do this? Thanks in advance.[/vbc
ol]

If you don't already have a control in the report computing Pages,
i.e. = "Page " & [Page] & " of " & [Pages]
add one.

Then code the Page Header format event:.

[ControlName].Visible = Me.[Page] = [Pages] <-- 这个coding 可以用得吗？

The control will display only on the last page.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail