Results 1 to 3 of 3

Thread: Printing - alignment of currency [RESOLVED]

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2005
    Location
    Wollongong. NSW. Australia
    Posts
    470

    Resolved Printing - alignment of currency [RESOLVED]

    I am using the following code in a loop to print cheque amounts

    Printer.CurrentX = 3300
    Printer.CurrentY = 4625 + i * 275
    Printer.Print .Fields!ChequeAmount

    The amounts vary from $20.00 to $20,000.00 How do I right justify it so that is correctly aligned? Is there a print using method?
    Last edited by Supremus; Apr 15th, 2006 at 04:44 AM.
    My reputation is in tatters. Don't bother trying to repair it.

  2. #2
    Fanatic Member eimroda's Avatar
    Join Date
    Jul 2000
    Location
    Philippines
    Posts
    642

    Re: Printing - alignment of currency

    VB Code:
    1. 'set a string variable with a length of 10, it would contain 999,999.99
    2. Dim strMoney AS String * 10
    3.  
    4. 'right=align it
    5. RSet strMoney = .Fields!ChequeAmount
    6. 'print
    7. Printer.Print strMoney
    do some error trapping, it will return an error if .Fields!ChequeAmount is null
    On Error GoTo Hell

    Hell:
    Kill Me


    Food For Thought:

    - Do not judge a book... if you're not a judge!


  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2005
    Location
    Wollongong. NSW. Australia
    Posts
    470

    Re: Printing - alignment of currency

    Oh. I had forgotten all about rset. Haven't used it in years. Thanks.
    My reputation is in tatters. Don't bother trying to repair it.

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