Jumat, 22 November 2013

RE: [MS_AccessPros] Controlling the format of a memo field

 

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

________________________________
> From: timdbui@gmail.com
>
> 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 (2)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar