[AccessD] Group and Page Break

Dear List:

 

I'm trying to product a report that will page break on the first character
of the last name field.  But I can't seem to get the report to page break.

 

I tries using the sorting and grouping - no soap.  

 

I tried this code in the Open even:

 

    Me.GroupLevel(0).ControlSource = Me.fldParentCustodialLastName
    Me.GroupLevel(0).GroupOn = 1
    Me.GroupLevel(0).GroupInterval = 1
    Me.GroupLevel(0).KeepTogether = 1


but it says that Me.fldParentCustodialLastName has no value.  Maybe not
loaded yet or something?

 
Anyway, does anybody know how to do this?  Doing it through the Sorting and
Grouping would probably be better that code.
 
MTIA
 


 

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>