Results 1 to 4 of 4

Thread: Text field in Access database.

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 1999
    Posts
    36

    Post

    I am creating an user interface where the user wants to store some information in a text field.I have to use an access database where the text field cannot be more than 255 characters.Is there any other way to store the information.If not ,how do I restrict the user for not exceeding the limit of 255??When he is esceeding the limit it is causing a run-time error.Please reply.

  2. #2
    Guru Aaron Young's Avatar
    Join Date
    Jun 1999
    Location
    Red Wing, MN, USA
    Posts
    2,176

    Post

    You could create another Table used to Store Multiple Lines of 255 Character Data, or you could set the MaxLength Property of the Textbox(s) to 255.

    ------------------
    Aaron Young
    Analyst Programmer
    aarony@redwingsoftware.com
    adyoung@win.bright.net

  3. #3
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    Set the maxlength property on the form.field to 255, if you want to use a text field. If you want to have the user to have more than 255 characters, use a memo field.

  4. #4

    Thread Starter
    Member
    Join Date
    Nov 1999
    Posts
    36

    Post

    I have changed it to a memo field and my problem is solved.

    Thanks for your help!!!!!

Posting Permissions

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



Click Here to Expand Forum to Full Width