Figure Numbers incrementing over Page Breaks

[jezzamax]

I have a subreport which displays a simple title and text field. There is also code in the Detail_Print event that creates a figure number by calling a function GetNewFigNum() which simply increments a global variable intFigCounter by 1.



Works fine, except when the subreport is called by the main report, and the subreport goes over a page break, then the code in the Detail_Print event gets called twice and intFigCounter gets incremented again.

How can I handle the page break problem?

[apr pillai]

Check the Format Count value to prevent incrementing the variable twice:

if formatcount = 1 then
  intFigCounter=intFigCounter+1
end if

[jezzamax]

OK - I have used the FormatCount value as suggested and this works perfectly if you just look at the SubReport in Print Preview.

BUT when I print preview the main report, the figure numbers generated in the sub-report still increment when there is a page break.

The code I am using is below :

 
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) 
If FormatCount = 1 Then
  If Me.chkHasFigure = True Then
    Me.txtFigNum = GetNewFigNum()
    Me.txtFigRefer = "Refer to Figure " & Me.txtFigNum & "."
    Call UpdateToc("Figure " & Me.txtFigNum & ". " & Me.txtFigureCaption)
  End If
End If
End Sub

[jezzamax]

Actually I have just figured this out. I changed FormatCount to PrintCount anbd eveything is working