Addressing seperate pages on a report

[Marcel Stoop]

Following is my problem

- Report consist of say 20 pages
- The field on which I have to check is: txtX (txtX is an unbound field in
the group header)
- On every separate page of the report txtX could have a different value
- As soon as the value of txtX on the next page changes, I have to make
another field (txtY) visible
- If the value of txtX on the next page does not change, field txtY should
be invisible

The visible and making invisible part is not the problem.

The real problem is:
Is it posible to check the value of field txtX on the seperate pages of the
report (using by format).

Thanks for the help
Marcel

 

[Marshall Barton]

Following is my problem

- Report consist of say 20 pages
- The field on which I have to check is: txtX (txtX is an unbound field in
the group header)
- On every separate page of the report txtX could have a different value
- As soon as the value of txtX on the next page changes, I have to make
another field (txtY) visible
- If the value of txtX on the next page does not change, field txtY should
be invisible

The visible and making invisible part is not the problem.

The real problem is:
Is it posible to check the value of field txtX on the seperate pages of the
report (using by format).

Try this. Add a hidden text box named txtZ to the whatever
section contains the txtY control. Then add this kind of
code to the section's Format event:

Me.txtY.Visible = (Me.txtX<> Nz(Me.txtZ, "junk"))
Me.txtZ = Me.txtX

 

[Marcel Stoop]

Thanks for the help

I will try it, and let you know if it worked.

Cheers
Marcel

 

[Marcel Stoop]

Many Thanks Marsh

It works great, just what I was looking for.

Cheers
Marcel

Thanks for the help

I will try it, and let you know if it worked.

Cheers
Marcel