Results 1 to 2 of 2
  1. #1
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19

    Problem with Euro formatting (123.456,78) on Microsoft Access Report

    Hello,




    On my report in Microsoft Access for all fields I have set-up this code in Control source:
    =Replace(Replace(Replace(Format(Sum([NameOfTheField]),"#,###.00"),".",""),",","."),"",",")
    and on this way I managed to replace format "123,456.78" to "123.456,78" because I need to have Euro formatting on report.
    This code works ok but problem is when some column contains zero value, then I would like to replace "0" with "-" and I don't know how to achieve this?

    And help is appreciated and many thanks for prompt replys!


    Cheers

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Maybe with an IIf expression
    =IIf([NameOfTheField]=0, "-", Replace...)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. A problem occurred while Microsoft Access...
    By nchesebro in forum Programming
    Replies: 16
    Last Post: 03-04-2011, 04:19 PM
  2. #Name? Conditional Formatting Report
    By stosh59 in forum Reports
    Replies: 5
    Last Post: 01-10-2011, 02:40 PM
  3. Formatting numbers in a report
    By bullwinkle55423 in forum Reports
    Replies: 1
    Last Post: 11-09-2010, 01:12 PM
  4. Replies: 0
    Last Post: 10-13-2010, 03:28 PM
  5. Conditional formatting in report
    By RickM in forum Access
    Replies: 1
    Last Post: 09-10-2009, 06:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums