Access 2003: Report - Group Totals - a diff. approach - getting error
Posted on 2011-03-23
Can group fields on the report be affected with vba logic?
I tried to total the credits during detail process by accumulating to a public variable.
If total > 0, print the student's academic standing field
If total = 0, print 'IN PROGRESS"
In the group's print event and even the format event tried this, and am getting an error:
Private Sub GroupFooter1_Print(Cancel As Integer, PrintCount As Integer)
If pg_lngTotCredits = 0 Then
Me.txtTermStanding = "IN PROGRESS"
pg_lngTotCredits = 0
tx for your ideas and advice, sandra