[AccessD] Group and Page Break

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Sun Mar 29 14:32:28 CDT 2009


That would be cheating.  And too easy.  And effective.  And clever.  I'm
there!

Thanks you. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe O'Connell
Sent: Sunday, March 29, 2009 11:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [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/> 

 

 

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list