Results 1 to 4 of 4
  1. #1
    lumiere is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Dec 2019
    Posts
    6

    Advantages of variation in character limits?


    Short text data type comes with default 255 characters. If it is decreased, say to 50, is there any advantage in doing so? Does it take less memory compared to default size?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm pretty sure there is no penalty. MS Access only uses whatever character spots you used.

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    According to microsoft
    You should use the smallest possible FieldSize property setting because smaller data sizes can be processed faster and require less memory.
    That said, I tend to agree with RG that it probably has little to no noticeable impact.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I don't think it will make a difference in file size because the disk allocation is based on the data type.
    @Moke123 - have seen that before, but I think it means, for example, you should use integer if integer works rather than using double, which would also work but consume more memory (and space). I don't think that has anything to do with limiting what you can put in a field, but that's just my interpretation. So a text field limited to 25 characters will perform no better than one that is limited to 255. IMHO, the only point to a limit is to control input so that (e.g.) you cannot add 5 characters to a field that should only have 4.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Defining Query Relationship Advantages?
    By kd2017 in forum Access
    Replies: 2
    Last Post: 02-23-2018, 01:23 PM
  2. Replies: 18
    Last Post: 10-11-2017, 03:07 PM
  3. Variation of past and current sales
    By v!ctor in forum Access
    Replies: 2
    Last Post: 03-16-2013, 09:06 AM
  4. Character Limits
    By nashr1928 in forum Reports
    Replies: 5
    Last Post: 12-08-2010, 01:29 PM
  5. Sort Order Variation with nulls
    By jonsuns7 in forum Queries
    Replies: 1
    Last Post: 10-09-2009, 03:10 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