timdbui (name?),
You can try use two adjacent text boxes with control sources like:
=IIf(Len([MemoField] & "")>40,Left([MemoField] & " ",InStr(Len([MemoField] & " ")\2,[MemoField] & " "," ")),[MemoField])
=IIf(Len([MemoField] & "")>40,Mid([MemoField],InStr(Len([MemoField] & " ")\2,[MemoField] & " "," ")),"")
If the total number of characters is <= 40 then it won't be split. If there are more than 40 characters, the expressions find a space in about the middle of the text and use it to split the memo field into two sections.
Duane Hookom MVP
MS Access
________________________________
> From: timdbui@gmail.com
>
>
> Hi, Would anyone please help me to solve this issue?
>
> I have a report that contains several data items and a large memo field
> ( about 1 page of text). I can print this memo field with the width of
> 7 inches from left to right of a page and use Can Grow feature.
> However, can I change the format of this memo field only, so that the
> memo field it self is displayed as 2 columns as in a newspaper style
> for ease of reading? I am not trying to print the whole report in 2
> column, just this memo field. Thanks in advance your your help! Tim
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar