Thank you, Jim and Duane! I got the file. This is great. It helps me so much.
Regards,
Tim
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Tim
go to
Then choose More from the text at the bottom of the graphic.
The drop down reveals Files
Choose files from the drop down
Choose 1_Samples
Then choose TwoColumnMemoReport.zip
Jim Wagner
On Thursday, October 31, 2013 6:15 AM, "timdbui@..." <timdbui@...> wrote:
Hi Duane,
Thanks again for creating the sample database. However, for some reasons, I can't find the "AccessSamples" folder anywhere on my Yahoo Group site. Yahoo has changed the layout and I can't find it. Would you be kind enough to show me how to get to this folder? Thanks Duane! Tim
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.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
________________________________
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@...
>
> 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@..."
> <timdbui@...> 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 (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar