[AccessD] Unorthodox Page Break

Lonnie,

    Sample code in Detail section's format event is given below:

    If  << Criteria Expression >> Then
        Me.Detail.ForceNewPage = 2
    Else
        Me.Detail.ForceNewPage = 0     ' (A)
    End If
    
    Choice of values for ForceNewPage property is as follows:
        0 - No forced page break
        1 - Before Section
        2 - After Section
        3 - Before & After Section

    Note - Inclusion of statement (A) in Else clause is necessary, otherwise the page break, once invoked, will continue to take place indiscriminately.

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Lonnie Johnson 
  To: AccessD solving' 
  Sent: Friday, May 26, 2006 23:26
  Subject: [AccessD] Unorthodox Page Break


  Is there a way to programatically start a new page within the detail format or detail print section if a certain condition was met with criteria in the records of a report?

  May God bless you beyond your imagination!
  Lonnie Johnson
  ProDev, Professional Development of MS Access Databases
  Visit me at ==> http://www.prodev.us