Results 1 to 12 of 12

Thread: [VBA] Change size of label

Hybrid View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Apr 2007
    Posts
    174

    Re: [VBA] Change size of label

    RobDog,
    I am not sure what you mean by "eval each label" to see which is the tallest.
    What would it change ?
    And also ONLY "description" and "memo" get bigger than everything else.
    But again, why this way would not work ?
    thanks

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Apr 2007
    Posts
    174

    Re: [VBA] Change size of label

    Does not seem to work...
    It is strange because the two vertical lines at the extremities are taller than the rest... but still they don't reach to the horizontal line

    I think it is the whole "if" thing that is posing problem.

    At the format event I have:
    [Report_Generic Report].Line31.Top = [Report_Generic Report].Descri.Height

    This is the horizontal line, and it works perfect.

    Then I have
    If [Report_Generic Report].Descri.Height >= [Report_Generic Report].Remarks.Height Then

    [Report_Generic Report].Line47.Height = [Report_Generic Report].Descri.Height
    else
    end if

    and this does not seem to work.

    It makes my original line smaller.

    --
    There seems to be something wrong with my code.
    I don't think "height" of a label is the same as "height" of line.
    When i ask to display height of label it gives me "270" ... ??

    When height is like 5.3 cm for example
    Last edited by Zoroxeus; Jun 13th, 2007 at 08:42 AM.

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Apr 2007
    Posts
    174

    Re: [VBA] Change size of label

    I attached the db file...
    thanks if you can take a look at it....
    It does not matter what I do... the number I get is always "270" ....
    (mdb file is renamed as zip)
    Attached Files Attached Files

Posting Permissions

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



Click Here to Expand Forum to Full Width