Tim,
When visiting our group site, drop down the "More v" and select "Files". The folder and file list will display. Click on the folder "1_Samples" to display this page http://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/1_Samples. Scroll down to find the file.
Duane Hookom MVP
MS Access
________________________________
> From: timdbui@gmail.com
>
> 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
>
> ________________________________
>> From: luvmymelody@...<mailto: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@...<mailto:timdbui@...>"
>> <timdbui@...<mailto: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<mailto:MS_Access_Professionals@yahoogroups.com>,
>>
> <ms_access_professionals@yahoogroups.com<mailto: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 (8) |
Tidak ada komentar:
Posting Komentar