Printing from preview duplicates fields

[Steve Perrins]

I have written a fairly complex report which is created/populated using VBA.
The report is fired from a form with acViewPreview set :-

DoCmd.OpenReport strRep, acViewPreview

The report looks fine in preview but when I print it it duplicates all the
fields I have.

If I change the code to :

DoCmd.OpenReport strRep, acViewNormal
the report also prints correctly.

I have another more complex report which uses VBA to populate the fields and
that works fine.

Any ideas help would be appreciated,

Thank you

Steve

 

[Steve Perrins]

Bypassed problem by adding a counter to vba code in the Detail_Format

nrepcount = nrepcount + 1
If nrepcount > 1 Then
Exit Sub
End If

nrepcount is a global variable