Need Help with Memo Field

[Guest]

I have added a memo field to a form and I have two problems. The first one
is if you enter text on the first line and go to the next line without
filling up the first line, the first text is all that goes to the table. Is
there a way to get the table to accept all information even if a line is
short?

The second problem is the text goes to the confirmation form as one long
line instead of having a line break. How do I insert a line break to keep
this from happening?

Thanks so much for your assistance.

 

[Guest]

Hi islandlover,

Sounds like you might be using a multiline control but are only saving to a
small text field (which would explain why only the first line is saved).

Check that the actual field in your TABLE is a memo field.

Hope this helps.

Damian.

 

[ruralguy via AccessMonster.com]

Look on the Other tab of the properties sheet for the TextBox control you are
using to display the Memo field. There is a property called "Enter Key
Behavior". Set it to "New Line in Field".

 

[Guest]

I checked and it is a memo field. I can generate a form and all the text is
there, but it doesn't appear in the table.

 

[missinglinq via AccessMonster.com]

Also be aware of some other problems you can have with memo fields. This is
from a file I have archived with stuff I've picked up over the years. To give
you some idea, the file is named MemoFieldAngst! I work in healthcare and
need to use memo fields for things like Progress Notes and such. The biggest
problem comes when there's any kind of formatting in the field.
***********************************************************************************************
Crosstab queries, Summary queries, Union queries, and Queries that use
Distinct
or DistinctRow will all truncate a memo field to 255 characters so Access can
perform the required functionality of eliminating duplicates.

Also, if you have specified a format in the field's Format property, I
believe
that will truncate the data that is displayed.

If Unique Value Property is set to Yes, Access has to compare the values and
therefore Memo Field values are truncated.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com