Custom Report Header

[mike wild]

I have a report listing members of a social group.
The report is split between Current and Past Members.

I have a yes/no check box on the main form based on weather each member is a current memebr or not. This is recorded in a table called "data" within the column called "member".

I have a unbound text box within the reports "Member Header" called currtxt.
I am trying to say:
If data![member] = -1 then
[currtxt] = "Current Members"
else
"Non-Members"
end if

I have tried this as a public procedure, and referencing it in the "currtxt" control source, and on format property.
Can this be done?

 

[The_Doc_Man]

Watch out of the OnFormat events. They don't fire consistently. In Report view no fire, in Print Preview fires perfectly.