Unlimited Length Memo

[lisal]

Hi, I have a form called "Comments" and what I am trying to do is insert some sort of object that will allow the user to enter an unlimited amount of comments. I tried using the Memo function but it only allows 255 characters. Does anyone know of anything I can use in a form that will allow the user to enter an unlimited amount of comments. Or anyone have any ideas on what I can do to stretch the maximum length of a memo. Thanks

 

[lameid]

The memo datatype in access has a maximum length of over 32,000 characters where as text has a limit of 255. Text fields can be indexed but memo fields can't. You could also create a subform which would allow users to enter multiple records for comments.

 

[UncleJack]

I presume your form is bound to a table that has a field called "Comments." Set the data type for this field in the table to Memo and that will permit entry of 64,000 characters on the form. It's a good idea to make this field on the form large enough to display several lines and set the vertical scroll bar on so a person can move up and down in the box for really long entries.

You can index a memo field by setting the index to only a certain number of characters of the memo field, e.g.

Left$(MemoField,255)

Cheers,

Uncle Jack

 

[CosmoKramer]

If the display of a memo field is restricted, check to see if there is any formatting of that control (i.e. a >). Remove that format and the full field will display.....