Results 1 to 2 of 2
  1. #1
    cap.zadi is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    KSA
    Posts
    481

    Decimal Values on a form

    Dear

    I have data entry form and need to enter some decimal values like:

    12.36 and 14.67 but

    even though i change the auto decimal to "2" and the format to standard its show the form field like then 00.00 but when enter any deicmal data it comes up with round up.



    please advise?

    thanks

    zee

  2. #2
    SteveH2508 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Chelsea, London, England
    Posts
    117
    Make sure that the bound field's data type is set to Single or Double - you probably have it set to Integer.

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

Similar Threads

  1. Changing decimal places
    By stupesek in forum Reports
    Replies: 12
    Last Post: 09-01-2010, 11:33 AM
  2. Need Currency or Decimal Help!
    By Jaricketts in forum Access
    Replies: 2
    Last Post: 08-19-2010, 09:39 PM
  3. Converting HH:MM to decimal
    By katrinanyc926 in forum Queries
    Replies: 5
    Last Post: 08-13-2010, 02:39 PM
  4. Replies: 3
    Last Post: 04-04-2010, 05:26 PM
  5. Get the sum of decimal values - weird results
    By BengtCarlsson in forum Queries
    Replies: 2
    Last Post: 02-10-2006, 04:29 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