Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FormatCurrency in a calculated textbox (Access 2000)

    We have an unbound textbox on a report whose control source property is a formula to concatonate several calculated fields. One of the concatonated fields is a number that we want displayed as US currency. (eg. $15.40). When we preview the report, the currency formatting does not work. We end up with 15.4 instead of $15.40. Any ideas?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: FormatCurrency in a calculated textbox (Access 2000)

    Instead of concatenating the field value itself, use the format function to make it look like what you want:
    = ..... & format(somefield,"currency") & ....
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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