Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Underline Amount Field On Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    How do I underline an amount field on a report for 8 numeric places

    Currently I use the font underline property of the text box and the underline is the length of the actual amount.

    Is there a format mask I can use to have the underline length portion 8 places long no matter how many numbers in the actual amount.

    <pre>This is what I have
    1.23
    ----

    This is what I want
    1.23
    --------
    </pre>


    Thanks, John

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Underline Amount Field On Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Hi John,

    Why don't you put a line under the texbox control ?
    Francois

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Underline Amount Field On Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I guess I could, was looking for some magic to do it it one control.

    Thanks, John

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Underline Amount Field On Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    <P ID="edit" class=small>(Edited by Francois on 20-Jul-04 18:35. )</P>You could use for a length of 8 characters :
    <pre>=Left(" ",-Len([YourNumber])) & [YourNumber]</pre>

    and set the underline property of the control to yes.
    Due to True type fonts, this will not be always the same for every record in a columnar report.

    Edited : There should be 8 spaces between the dubbel quotes but the lounge cut them. So I edit the post and inset the pre tag
    Francois

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Underline Amount Field On Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    The Magician returns!

    This is my final code:

    <pre>=Left(" ",16-Len([curStatuatoryFee])) & Format([curStatuatoryFee],"$0.00")
    </pre>


    Thanks, John

Posting Permissions

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