Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    89

    Unanswered: Format (Currency) doesn't work :-(

    Hi. I've got a datasheet which when you click on a row it opens up a report.

    At the top I've got a row of text boxes in the report header, that show exactly what the datasheet shows (e.g. Forms![RentMonitor]!AmountDue).

    The datasheet format for the AmountDue column is
    Code:
    £#,##0.00[Black];-£#,##0.00[Red]
    And this works perfectly. However in the report, when i use this format it just shows it as a number (i.e unformated). I've tried chanigng the format to currency, I've tried setting the Input mask to £#,###.## but that only worked for positive values.


    Any ideas?

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    Try this:
    =CCur(FIELDNAME)
    Regards
    JD

    Software-Matters

  3. #3
    Join Date
    Jun 2009
    Posts
    89
    Perfect! THanks

Posting Permissions

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