Need to expand # of characters allowed in a form, in a database.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Megan Carlin

    Need to expand # of characters allowed in a form, in a database.

    I know that a memo has a character limit of 255 but one of our fields (not sure if it's a memo or what!) is topping out at around 210 characters, including spaces (with space available in the form to still be written in). How can I allow more information to be written in the field? I can provide whatever info is needed...
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    1. A TEXT Field in Access can hold a Maximum of 255 characters.
    2. A MEMO Field can hold a Maximum of 65,535 characters.

    Comment

    • munkee
      Contributor
      • Feb 2010
      • 374

      #3
      Indeed as ADezii has pointed out as long as there is no character limit set within the form itself you should check the table. It is likely as said above you have it set to TEXT and not MEMO

      Comment

      Working...