Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Gillingham, Kent, England
    Thanked 0 Times in 0 Posts

    Changing the field length in a form (Access 97 SR2)

    I have an SQL table that is used by many databases, with a view for each database to create the illusion that each has it's own table.
    This setup generally works fine, however, there are standard field set ups which cannot be changed. I am left with a Memo field which i'd like to restrict to 150 characters.
    I'm looking for a way of doing this either in the SQL view or the form view within the database.
    Any help would be much appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Changing the field length in a form (Access 97 SR2)

    If you want to restrict it to 150 characters, why use a memo field? A text field is automatically restricted to whatever length you specify, up to the maximum 255. If you must use a memo field for whatever reason, you can use the Change event of the control on the form to test the length of the control's text property and simply truncate anything over 150.

Posting Permissions

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