Display page numbers only if report is more than 1 page

[JiTS]

Hi,

I would like to display the page numbers on the pages of my report, but only if the report is more than one page.

How to do this in the design and/or VB area?!?


Thanks in advance,
JiTS

 

[JiTS]

I got it!

I added the following code in the controlsource of the page number textfield:

=IIf([Pages]>1;"page# " & [Page] & " van " & [Pages])

This means if the report is more than one page then it will display the pages.


*SMiLE*
JiTS

 

[rsewell]

similar problem

JiTS,

I'm looking for something that will explain the syntax that you used... where did you find it?

Thanks!

 

[JiTS]

Actually, I did not find it somewhere but I figured it out by myself I guess...

I will try to explain it to you.

The next code is the same as an if statement in VB but you enter this code in the controlsource of your text box.

=iif(expr;true;false)

expr: this the expression
true: this is the commando to do if the expression is true
false: this is the commando to do if the expression is false

For example:
=iif([OrderID]=0;txtOrderID.visible=false;txtOrderID.visible=true)

If OrderID = 0 then the text box txtOrderID is not visible, otherwise it is.

This is my best english answer for a Dutch guy!


*SMiLE*
JiTS

 

[coastguard]

Thanks for the explanation, It's helped me to think through a problem on a different matter.

 

[JiTS]

No problem at all!

*SMiLE*
JiTS

 

[rsewell]

Ohhhhh, I get it now.

Trust me, your English is better than my Dutch.

Danka Shen (hope thats spelled right)

 

[JiTS]

Danka Shen

First of all I am Dutch, not German (see quote)... and in The Netherlands you could say 'Dank je wel' or 'Bedankt'.

Don't start with the bad words in Dutch because that's not very nice on this forum...

*SMiLE*
JiTS

 

[expat1000]

IIf([Pages]>1,"page# " & [Page] & " of " & [Pages])

Comma, not semi-colon after 1