Results 1 to 2 of 2
2001-09-04, 16:24 #1
- 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.
2001-09-04, 20:35 #2
- 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.Charlotte