Thanks, Duane! I need to read a little bit more about Access to understand your advice. My knowledge of Access is not that deep yet to be able to apply the codes.
Tim
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote:
Tim,
My first suggestion would be to consider splitting multiple data items into a related/child table rather than a single memo field. IMO, if you have more than one item, there should be more than one record.
If the text displays in multiple lines in the form, I expect there are carriage return characters in the field. Since the report doesn't display correctly you could try use an expression that replaces the carriage return with a carriage return and line feed:
=Replace([Your Memo Field Name], Chr(13), Chr(13) & Chr(10))
Make sure the name of the text box is not the same as the name of the field.
Duane Hookom MVP
MS Access
________________________________
My first suggestion would be to consider splitting multiple data items into a related/child table rather than a single memo field. IMO, if you have more than one item, there should be more than one record.
If the text displays in multiple lines in the form, I expect there are carriage return characters in the field. Since the report doesn't display correctly you could try use an expression that replaces the carriage return with a carriage return and line feed:
=Replace([Your Memo Field Name], Chr(13), Chr(13) & Chr(10))
Make sure the name of the text box is not the same as the name of the field.
Duane Hookom MVP
MS Access
________________________________
> From: timdbui@...
>
> Hi, would any of you please advise if if this is possible in a memo field?
>
> I created a memo field on a form to record notes. The notes have
> several items as:
> 1. xxxx
> 2.yyyy
> 3.zzzz
>
> However, in my report for print out, all of the 1,2,and 3 are
> concatenated and become:
> 1. xxxx2.yyyy3.zzzz
>
> Is there a way to keep the 1,2, and 3 separated as different lines?
>
> Thanks so much!
>
> Tim
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar