Re: make page footer invisible

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for responding. I fixed the problem by moving the test up into the
page header section. I guess that gives it a better place in the timing of
things. With the test in the detail section, the results were incorrect, but
there was a pattern. Every time there were 2 records in a row that should
display, the first was triggered. If there was only one in a row, it would
not not display.
--
Alan


"John Spencer" wrote:

I would try
Me.Section(acPageFooter).Visible = False

Or even
[Reports]![payment receipt].Section(4).Visible = False

Also I see you are testing for 0. Is it possible that the value is not
zero, but is Null or some value very close to zero? You can handle that
with a test as follows

If Abs(Nz(Me.Expr2,0)) < .00000001 Then
Me.Section(acPageFooter).Visible = False
End If
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"adgorn" <adgorn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:859D1D05-A745-4B81-A93E-0C2579370DBF@xxxxxxxxxxxxxxxx
In the detail section of a report called Payment Receipt , I display the
result of a query, Expr2, in a text box. (This will be a number (dollar
amount) that is different for every record. FYI the text box is also
called
Expr2.) If that value = 0, I do not want the page footer to display. So
I
used the following code in OnFormat for the detail section:

If [Reports]![payment receipt].[Expr2] = 0 Then
[Reports]![payment receipt].[Section](4).Visible = False
End If

It doesn't work. Any help? Thanks.
--
Alan



.

Relevant Pages

  • Re: Comparing Row by Row - A-D dollar amounts to E dollar amount
    ... I'm thinking this will display nothing (instead of zero) so that when I ... "Mel" wrote: ... formula below) in a header name populating when it should be BLANK. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Supressing Detail Section of Report
    ... >If the sum is zero, I need to supress the detail and display only the ... Just use a little code in the header section's Format event ...
    (microsoft.public.access.reports)
  • REPRESENT revisited
    ... Forth-94 has few floating point display functions [none in the ... If u is greater than zero the character string shall consist ... If u is zero the string shall consist of one digit representing ...
    (comp.lang.forth)
  • Re: Hide detail if only one record
    ... of records for display in the detail section. ... report and repeat the solution attempt, ... "John Spencer" wrote: ... tracking married couples' names and the children they have, ...
    (microsoft.public.access.reports)
  • Re: Hide detail if only one record
    ... of records for display in the detail section. ... report and repeat the solution attempt, ... "John Spencer" wrote: ... tracking married couples' names and the children they have, ...
    (microsoft.public.access.reports)