Header statement construction

[Therat]

There is probably a simple answer to this question. I can't get a particular statement to work in the header that works in the footer.

=[MSA] &" Region"

When I preview this statement from the header in reports I see "#Error." Yet this same statement works in the footer. Any thoughts?

Thanks in advance,
Therat

 

[WayneRyan]

Therat,

What version of Access are you using? I'm guessing its A97 or
below.

I would have expected the #Name error instead.

I think that A97 flows like this:

HeaderFormat
HeaderPrint
DetailFormat
DetailPrint
.
.
.
Detail Format ' Won't be on the page
FooterFormat
FooterPrint

So when processing the header, I don't think you've seen
the first detail yet, so [MSA] has no value. By the time it gets
to the footer, it has seen [MSA] so it works.

If this is the case, your header should be correct after page 1,
although with the previous page's [MSA]. If this is the case for
every page, then its not really set up as in the footer.

Wayne