Results 1 to 3 of 3
  1. #1
    insah is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2011
    Posts
    1

    Table List and currency

    1. How do you create a table list?

    2. I created a database last week where I was trying to use an imput mask for the dollar sign. But every way that I entered the information into the design view, would zero out my cents field. For example, if I entered 3.33, the input mask would enter it as $3.00.

    How can I create an input mask that with insert the $ sign, and allow me to enter the exact cents.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    change the control's data type property to currency?

  3. #3
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    If you just only want to display it as currency format,
    just change the field property's display format to something like that
    $#,##0.00

    It will display correctly, but the data will be what you have entered.
    For example,
    you type 11.123
    and the display would be $11.12

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

Similar Threads

  1. Indian Currency
    By nithubp in forum Access
    Replies: 6
    Last Post: 07-08-2014, 01:56 AM
  2. Need Currency or Decimal Help!
    By Jaricketts in forum Access
    Replies: 2
    Last Post: 08-19-2010, 09:39 PM
  3. Currency Vs Double
    By Mclaren in forum Database Design
    Replies: 1
    Last Post: 08-12-2010, 05:38 PM
  4. HELP! formatting currency
    By jgelpi16 in forum Reports
    Replies: 1
    Last Post: 07-06-2010, 09:04 AM
  5. Currency Problem
    By EHittner in forum Access
    Replies: 1
    Last Post: 11-05-2009, 09:46 PM

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