VBA script executes thrice per OnFormat in Report? how to do it only once (1 Viewer)

[sumox]

I have a report and in rpt-footer ,some values/txtboxes
haf to be fetched to vba for calculating or External Excel file writing

now I've activated OnFormat Event , which executes the
script thrice per Preview !:banghead:

how to stop dat dammn thing, and execute only once

i am using ACC2003+win7 O.S.
The Report has no other scripts on any section

 

[Reenen]

Set a global variable AlreadyDone (or whatever)

Set it to false when you intialize, and then at the start just check if AlreadyDone=true, skip to the end.