Limit Memo Filed to 255 Characters

[crhodus]

Is there a way to limit a memo field to 255 characters or at least tell the user that he has typed more than 255 characters? I would change this field to a text field, but I have data from an old system stored in this field that is more than 255 characters long.

I have to stay under the 255 character limit because this data will be exported to an Excel sheet and Excel cannot handle more than 255 characters. Any help or suggestions would be greatly appreciated.

Thanks!

 

[AlanS]

If the field is named Memo1, set its ValidationRule property to:

Len(Memo1) <= 255

and set the ValidationText property to an appropriate error message.

 

[crhodus]

Hi AlenS,

I tried entering in
=Len([Notes]) <= 255
for the Validation Rule property for my field named Notes, but it doesn't seem to be displaying my Validation Text message that I entered in. Any other suggestions?

Thanks!

 

[AlanS]

You should only see that message when you attempt to enter a string longer than 255 characters. Also, be sure the field name is typed correctly - any deviation will cause an error or result in a reference to the wrong object.

[This message has been edited by AlanS (edited 08-13-2001).]

 

[JonatABS]

longer then 255 Chars

On a side note is there a way to get an unlimited size limit or do you guys have any suggestions on how to do somthing like this. I have a database that allows users to track problems with our software and hardware. However these tend to be long.

Any suggestions would be greatly appreciated.

keep in mind I that I need these to be printed on a report and Id rather not have to have the user(s) have to start typing in another text box to continue their note.

Thanks
Jon

 

[DJN]

If it's of any help, the size of a text box is limited to 255 characters, the size of a memo field is 65535 characters through a user interface and i gig through code. You can set the 'Can Grow' property to yes in the reports properties.


David