Results 1 to 4 of 4
  1. 01-23-2019, 11:46 PM #1
    SierraJuliet's Avatar
    SierraJuliet
    SierraJuliet is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2017
    Location
    Earth
    Posts
    211

    Stop auto increment of decimal value to 1

    How do I stop MS Access 2013 from auto increment a decimal value to 1.
    For example, I enter $0.55 but access automatically changes to $1.00 after entry.


    This is a form field with data format type set to currency and decimal places set to 2.
    The table value is set to Number with field size set to Long Integer and decimal places set to Auto.
    Reply With Quote Reply With Quote
  2. 01-23-2019, 11:52 PM #2
    davegri's Avatar
    davegri
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413
    An integer by definition is a whole number, no decimal places. Change your table def from long integer to currency.
    Reply With Quote Reply With Quote
  3. 01-24-2019, 12:34 AM #3
    SierraJuliet's Avatar
    SierraJuliet
    SierraJuliet is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2017
    Location
    Earth
    Posts
    211
    Will the "currency" data type give an issue later if backend is MySQL or MSSQL?
    Reply With Quote Reply With Quote
  4. 01-24-2019, 01:10 AM #4
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Review https://blogs.msdn.microsoft.com/ssm...e-conversions/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Stop Counter Increment When Aborting Record Entry
    By Beanie_d83 in forum Modules
    Replies: 7
    Last Post: 06-21-2018, 08:14 AM
  2. Auto Increment ID
    By KBNETGUY in forum Programming
    Replies: 9
    Last Post: 04-18-2018, 10:22 PM
  3. Auto Increment / Auto Number without using standard "autonumber" field
    By Eddy Sincere in forum Forms
    Replies: 2
    Last Post: 12-29-2016, 11:42 AM
  4. Auto increment a number and be able to modify value after increment has taken place.
    By markw in forum Database Design
    Replies: 5
    Last Post: 11-12-2010, 12:10 PM
  5. Is there a way to specify a value when using an auto-increment field
    By mydarkpassenger in forum Access
    Replies: 2
    Last Post: 12-08-2009, 01:19 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums