+ Reply to Thread
Results 1 to 4 of 4

Setting Character Limit on a Text Box

  1. #1
    Registered User
    Join Date
    01-07-2020
    Location
    Columbus, Ohio
    MS-Off Ver
    2019
    Posts
    70

    Question Setting Character Limit on a Text Box

    Hello! I was wondering if it is possible to set a character limit on a Text Box in Access? For example, if I have a Text Box called 'Accounts' linked to a field called 'Accounts' in a database, can I make it so users MUST input nine characters (no more, no less) or they would see an error? I tried a few different code snippets in VBA but could not get it to work. Please let me know if you need more information. Thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,250

    Re: Setting Character Limit on a Text Box

    Have you tried setting the limit in the underlying table.
    Attached Images Attached Images

  3. #3
    Registered User
    Join Date
    01-07-2020
    Location
    Columbus, Ohio
    MS-Off Ver
    2019
    Posts
    70

    Re: Setting Character Limit on a Text Box

    Yep, that worked. Should have tried that first. I was over-complicating it. Thanks a ton!

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,250

    Re: Setting Character Limit on a Text Box

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to set the max character limit of a text box in VBA to 4 digits
    By Karol2573 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2016, 05:28 AM
  2. Character limit in text box when linked to a cell?
    By mfernandes in forum Excel General
    Replies: 6
    Last Post: 01-08-2016, 07:45 AM
  3. Character Limit in Text Box
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-10-2015, 01:54 PM
  4. Replies: 1
    Last Post: 11-27-2013, 04:53 PM
  5. Replies: 2
    Last Post: 02-14-2010, 01:03 PM
  6. Text box character limit
    By Mickey in forum Excel General
    Replies: 0
    Last Post: 05-22-2006, 03:35 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1