Memo format

[Guest]

Does anybody know how I can make a field hold many paragraphs? I looked up
the help menu said change it to memo that it would hold 64K plus characters.
Well, it doesn't. Is there any other way to make a large field?
Thanks,
Tammy

 

[fredg]

Does anybody know how I can make a field hold many paragraphs? I looked up
the help menu said change it to memo that it would hold 64K plus characters.
Well, it doesn't. Is there any other way to make a large field?
Thanks,
Tammy

It sure does hold 64K+ characters.
Perhaps, if you are more specific about what you are doing, someone
can tell you what you have done incorrectly.

 

[Rick B]

What do you mean it doesn't? A memo field can hold that amount of data. To
insert a carriage return when typing into a memo field, press CTRL+Enter.

 

[Guest]

I have a "comment" field in my database - the datatype is set to Memo - it
will only hold approx 250 characters. I'm not sure what to do?

 

[John Vinson]

I have a "comment" field in my database - the datatype is set to Memo - it
will only hold approx 250 characters. I'm not sure what to do?

Just be sure that you're not doing any of these things, any of which
will truncate a Memo field:

- defining a Format on the field, either in the table or in the Form
textbox bound to the field
- Defining an Input Mask, likewise
- Sorting by the field
- Grouping by the field

John W. Vinson[MVP]