[AccessD] Group and Page Break

Rocky,

Could you add another field to the record source for the report that
contains just the first character of the last name?  Then just use this
field for the group and go to a new page after each group prints.

Joe O'Connell


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Sunday, March 29, 2009 12:54 PM
To: 'Access Developers discussion and problem solving'
Subject: [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/>