report refers to each query row twice when using 'on print' event

[Roger]

I've got a table with one field (id) and one row (id = 1)
I've got a query based on the table that calls a function

select func(id) as idText from table

The function 'func' is

public function func(strId as string) as string
func = strId
end function

If I run the query with a breakpoint on 'func = strId', it gets hit
once

If I create a report based on this query and place the field 'idText'
in the detail portion of the report... the breakpoint above is hit
once when I run the report... so far ... ok
If I add a on-print event
if [idtext]="2" then
stop
end if

the breakpoint in the function above gets hit twice ?
why ?
is there away to prevent this, since my final function will update
global variables that I don't want to double up ???

I thought [idtext] would refer to the report field that already had a
value ...

[Salad]

Roger wrote:

If I add a on-print event
if [idtext]="2" then
stop
end if

Why not enter
If [idtext] = "2" then Cancel = True

What is STOP?

[Roger]

the table has only one row with an id of "1"
the function that is called will return 1+1 =2 and I've given this
column an alias of idtext

so "2" doesn't mean it is coming in the second time... in both case
the field contains "2"

but it looks like when referring to the column alias "idtext", it
re-evaluates the function instead of reusing the first computed
result...
by the way "stop" hardcodes a breakpoint in your vba code so you don't
have to find it and hit <f9>

Salad <oi*@vinegar.com> wrote in message news:<3F***************@vinegar.com>...

Roger wrote:

If I add a on-print event
if [idtext]="2" then
stop
end if

Why not enter
If [idtext] = "2" then Cancel = True

What is STOP?