Tim
I would love to try this out also, but I cannot picture it in my mind at what that would look like. Post an image of the results on the pictures page if you can
Thank you
Jim Wagner
On Wednesday, October 30, 2013 10:45 AM, "timdbui@gmail.com" <timdbui@gmail.com> wrote:
Thanks so much for taking the time to help me, Duane! I will try it out. Tim
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
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
________________________________
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@...
>
>
> 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 (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar