Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Adelaide, South Australia, Australia
    Posts
    146
    Thanks
    5
    Thanked 5 Times in 5 Posts

    Decimal vs Double Field Size in Access

    This probably qualifies as Stupid Question of the Day, but having been around Access since V1, I didn't really notice when the Decimal option arrived for field sizes, and have tended to use Integer, Long Integer, Double and Currency most of the time.

    Looking at Decimal, though (currently working in Access 2010), there seem to be many advantages over Double - very flexible number sizes and decimal precision, but only 2 bytes of storage.

    Which stokes my paranoia and leaves me wondering what the catch is.

    Can anyone confirm that Decimal is/is not a good option to use?

    Cheers

    AlisonC

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Seems Decimal was not problem free, at least still in Access 2007 - no support in VBA, a bug when sorting. This thread describes some of the issues: http://groups.google.com/group/micro...6210b291?pli=1

    Some of the issues may have been sorted in Access 2010, but others are still there - no VBA direct support.

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Alison,

    Here's another link to problems with the Decimal type in Access.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Adelaide, South Australia, Australia
    Posts
    146
    Thanks
    5
    Thanked 5 Times in 5 Posts
    Many thanks to you both - while I was waiting to see what suggestions came up, I tried playing around a bit, and quickly came up with either things I didn't like (eg while setting the properties) or other things that just didn't seem to work, so it was no surprise to find the articles you referred me to were not overwhelming in their support of Decimal! But it was good to have confirmation that it wasn't just my klutziness that was causing my dislike of this option.

    Cheers

    Alison C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •