Duane,
Thank You, That is really sweet. I like it. I am documenting the sql statements for a database and this will work great.
Jim Wagner
On Wednesday, October 30, 2013 12:21 PM, Duane Hookom <duanehookom@hotmail.com> wrote:
Jim,
I created a small sample database (TwoColumnMemoReport.zip) and uploaded it to the AccessSamples folder for our group.
It won't necessarily break the memo field into equal length columns since it relies on counting characters, not lines.
Duane Hookom MVP
MS Access
________________________________
> From: luvmymelody@yahoo.com
>
> 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
>
> ________________________________
>> From: timdbui@...<mailto: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
I created a small sample database (TwoColumnMemoReport.zip) and uploaded it to the AccessSamples folder for our group.
It won't necessarily break the memo field into equal length columns since it relies on counting characters, not lines.
Duane Hookom MVP
MS Access
________________________________
> From: luvmymelody@yahoo.com
>
> 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
>
> ________________________________
>> From: timdbui@...<mailto: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 (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar