[AccessD] Removing blank line from a report

MessageMark - if the text box for [Addr2] overlaps any other controls at all, then the 'Can Shrink' won't happen. Another thing to check.

Kath
  ----- Original Message ----- 
  From: Mark Boyd 
  To: accessd at databaseadvisors.com 
  Sent: Wednesday, February 12, 2003 4:03 AM
  Subject: RE: [AccessD] Removing blank line from a report


  I guess I misunderstood.

  I can set the field properties, but not the page header properties.

  Doesn't the section's CanGrow and CanShrink properties need to be set in order to affect the fields' CanGrow and CanShrink properties?



  Mark



  -----Original Message-----
  From: Stuart Sanders [mailto:stuart at pacific.net.hk] 
  Sent: Tuesday, February 11, 2003 11:42 AM
  To: accessd at databaseadvisors.com
  Subject: RE: [AccessD] Removing blank line from a report



  The property exists in my copy of Access 2000 for fields in the Page Header.



  Stuart

    -----Original Message-----
    From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark Boyd
    Sent: Wednesday, 12 February, 2003 12:06 AM
    To: accessd at databaseadvisors.com
    Subject: RE: [AccessD] Removing blank line from a report

    Susan -

    What version of Access are you using?

    This project uses Access2000.



    Mark



    -----Original Message-----
    From: Klos, Susan [mailto:Susan.Klos at fldoe.org] 
    Sent: Tuesday, February 11, 2003 10:57 AM
    To: 'accessd at databaseadvisors.com'
    Subject: RE: [AccessD] Removing blank line from a report



    I have a report with the same type of controls in the page header.  I get a CanShrink proterty for the control.

      -----Original Message-----
      From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com]
      Sent: Tuesday, February 11, 2003 10:30 AM
      To: accessd at databaseadvisors.com
      Subject: RE: [AccessD] Removing blank line from a report

      Brett -

      The problem with that is the fields are in the page header . no CanShrink property there.



      Thanks,

      Mark



      -----Original Message-----
      From: Brett Barabash [mailto:BBarabash at tappeconstruction.com] 
      Sent: Tuesday, February 11, 2003 10:21 AM
      To: 'accessd at databaseadvisors.com'
      Subject: RE: [AccessD] Removing blank line from a report



      Assuming that each field is in a separate TextBox, all you need to do is set the Report section and TextBox CanShrink property to True.  Access will take care of the rest for you!



        -----Original Message-----
        From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com]
        Sent: Tuesday, February 11, 2003 8:25 AM
        To: AccessD at databaseadvisors.com
        Subject: [AccessD] Removing blank line from a report

        I have a report that is formatted like a business letter.

        In the address section (which is in the page header), I have the following 4 fields:

        [BillingName]

        [Addr1]

        [Addr2]

        [CityStZip]



        How can I force the [CityStZip] up a line when [Addr2] is blank?

        Most of the addresses look like this:



        John Smith

        123 Main St.



        City, St  12345





        I tried setting the CanShrink property of [Addr2] to 'Yes', but this doesn't work.

        Any ideas?





        Mark Boyd

        Sr. Systems Analyst

        McBee Associates, Inc.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030211/801eef4d/attachment-0002.html>