Last page in report

[12011977]

I have one problem. Iwant to write some text on bootom of last page of my report , I dont know how manny pages it going to be but only on last one I need to put text

thanks

 

[ProgramError]

select the 'view/report header/footer' option in the toolbar


Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[dhookom]

Put you text in the bottom of the page footer section. Set the control source to something like:

=IIf([Page]=[Pages],"some text",Null)

Duane MS Access MVP

 

[12011977]

I tried =IIf([Page]=[Pages],"some text",Null)to write in Control source of text wich I want to show and get error

"you omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding in in quotation marks"

 

[genomon]

Could be trouble setting a text box to null?
Try =IIf([Page]=[Pages],"some text","")

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[12011977]

I am getting same error

 

[dhookom]

I copied and pasted the expression into the control source of a text box in a page footer on my report and it worked with no errors.

Duane MS Access MVP

 

[ck1999]

Create a new textbox and try this code

ck1999

 

[dhookom]

Are you using a language that requires:
=IIf([Page]=[Pages];"some text";Null)

Duane MS Access MVP

 

[12011977]

Now it works =IIf([Page]=[Pages];"some text";Null)

thanks for help

 

[genomon]

Hey Duane - what's up with the semicolon delim in VBA? Never saw it used in an IIf like that before.

Are you using a language that requires...

This is an Access form - there is something else besides VBA you can program it with? Where would the IDE be?

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[dhookom]

genomon,
By "language", I was referring to non-english. Other countries/locals might use different punctuation in expressions. These issues like date formatting aren't easily understood by some of us who don't experience them.


Duane MS Access MVP

 

[BSman]

As Ian suggested, just view the report footer and in the report footer place the text you want to be on the last page of your report. Works like a charm.

Bob