Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format Text to Currency

    In Access 97 I have 2 fields one containing a number in currency format and the other a text value. A value will be in either one or the other fields not both.

    What I want to be able to do on a form field is display the currency value if it exists else show the text value. Usually no problem, but I can't seem to get the currency number to display in currency format.

    I have tried several things including:-

    InvDis: IIf(Nz([Invoice])="",[InvoiceNote],CCur([Invoice]))

    Which gives me the right answer but no currency formatting on the currency field.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Text to Currency

    Caz:

    Try
    <hr>InvDis: IIf(Nz([Invoice])="",[InvoiceNote],Format([Invoice],"Currency")<hr>

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Text to Currency

    Silly me, the answer is always simple.

    Thanks very much is works fine now

Posting Permissions

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