Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: setting pageheader hieght with vba

    i have 2 rows of labels in my page header, i would like to hide the second row sometimes, but this leaves a big blank in my header, i tried

    me.PageHeader.Height = 1.7917

    but i get a compile error " Invalid qualifier"

    also, can i set the height smaller than the lowest group of labels in that area if i set thier visible = false?

  2. #2
    Join Date
    Nov 2003
    Me.PageHeaderSection.Height = 1.7917 * 1440

    Always remember....When in design view the Properties deal with Inches (or cm) but in need to convert to Twips. 1" = 1440 Twips.

    to your second question...No. You will need to reduce their size as well.

    Last edited by CyberLynx; 11-20-07 at 00:00.
    Self Taught In ALL Environments.....And It Shows!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts