Results 1 to 2 of 2
  1. #1
    Symlink is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2013
    Posts
    42

    Currency formatting without the USD symbol

    I need to have a textbox formatted to have 2 decimals. If I take general number and set the decimal to 2 it will display numbers like 89.1. I would need it to be 89.10. I would like not to use the currency format as it puts the $ symbol in the textbox as well. So basically same formatting as currency (because it's a currency I am working with) but without the symbol.

  2. #2
    Symlink is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2013
    Posts
    42
    Okay I got it working using Round(Value; precision) and Format to 0.00

    There might be a much more simple way tho :/ anyway sorry thread auto solved

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

Similar Threads

  1. formatting a field to be currency in VBA
    By Lupson2011 in forum Forms
    Replies: 8
    Last Post: 06-25-2012, 08:02 AM
  2. Replies: 5
    Last Post: 12-10-2011, 11:49 AM
  3. Replies: 2
    Last Post: 03-23-2011, 11:43 AM
  4. HELP! formatting currency
    By jgelpi16 in forum Reports
    Replies: 1
    Last Post: 07-06-2010, 09:04 AM
  5. How Can I Modify the currency symbol programmatically
    By migo702000 in forum Programming
    Replies: 5
    Last Post: 11-03-2009, 04:34 AM

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