Memo Field

[Guest]

Hi,

I have a memo field into which I want to store "historical comments". The
idea is that everytime a user adds a comment into a "latest comments" memo
field, they cut and paste the previous comment into the "historical comments"
which is below it on my form.

The problem I have is that I can't add each comment onto a new line within
the "historical comments" field...I can only add it on the same row as the
previous one. So, rather than having a new line for each comment (rather
like bullet points), I end up with a long row of text.

I guess my question is - is there any way of putting a "carriage return" in
a memo field ?

Many Thanks
Pete

 

[Jeff Boyce]

Pete

There is ... and this may not be the best solution!

If you are saying that you can have multiple "historical comments", created
by (potentially) different users at different date/times, you may wish to
look into using one record per comment, rather than trying to stuff multiple
comments into one field.

You could create a tblComments table, related as the "many" side to your
primary table, and add each comment as a separate (but related) record.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[steve]

Try:

Me.[HistoricalComments] = Me.[HistoricalComments]&Chr(13) Chr(10) &
Me.[CommentUpdate]

Using your own field names of course.

HTH

Steve

 

[Guest]

Depending on how muc updating would be done, you could end up with an
un-writeable record. A memo field has a text-length limit of 32,000 bytes
(roughly). So you couldn't append forever. You'd have to check the length of
the existing text PLUS the length of your pending addition, and make sure it
wasn't too long. You'd have to abort the update and throw an error message if
that were about to occur. Far better to simply have one historical record per
entry.