• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

CCur Function not displaying as Currency. (1 Viewer)

Carpetwarehouse

Registered User.
Local time
Today, 07:56
Joined
Jun 11, 2012
Messages
25
I have a calculated field in a report footer which is as follows; CCur(Sum([Line Total]))

Where the answer should be £147.72

Im getting 147.722

Any ideas?
 

MarkK

Super Moderator
Local time
Today, 00:56
Joined
Mar 17, 2004
Messages
7,761
Check the format property of the textbox control that displays the result. Set that to currency.
 

Users who are viewing this thread

Top Bottom