Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Memo Length Restriction

Discussion in 'Information Technology' started by apollo8359, Jul 28, 2006.

  1. apollo8359

    apollo8359
    Expand Collapse
    Guest

    I have some users who are budding authors generating large memo fields.
    Because I have to run the report in landscape it reduces my page length for
    the expanding field. When the text box width is big enough for the entire
    memo to fit on one page it works, otherwise it hangs. I don't want to
    restrict the memo field, just cut off the output in the report. So, is there
    a way to limit the text box length of a growing memo field only in the
    report? Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Beyond Chamkaur: Wars, Battles & Memories Sikh Sikhi Sikhism Dec 23, 2015
    Memorial to the remarkable Sikh soldiers of WWI Sikh Personalities Oct 31, 2015
    Narayanjot Kaur Aka Spnadmin Some Memories Intellectual Articles Apr 28, 2015
    Gurus Commemorating The Painting Of Guru Gobind Singh Ji By Bhagat Singh Bedi History of Sikhism Apr 15, 2015
    UK UK Sikh Biker Group ‘Humbled’ to be on Lee Rigby Memorial Ride to Woolwich Barracks in Ilford Breaking News May 24, 2014

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 8 May 2006 16:11:01 -0700, apollo8359
    <apollo8359@discussions.microsoft.com> wrote:

    >I have some users who are budding authors generating large memo fields.
    >Because I have to run the report in landscape it reduces my page length for
    >the expanding field. When the text box width is big enough for the entire
    >memo to fit on one page it works, otherwise it hangs. I don't want to
    >restrict the memo field, just cut off the output in the report. So, is there
    >a way to limit the text box length of a growing memo field only in the
    >report? Thanks.


    You could base the Report on a Query with a calculated field:

    ShowMemo: IIF(Len([memofield]) > 2500, Left([memomemofield], 2500) &
    "... <see database>", [memofield])

    to cut their verbosity out of the report without affecting the actual
    stored data. Of course, adjust 2500 to your preference.

    John W. Vinson[MVP]
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Sure. Use a query as the recordsource for the report. Add a column for use
    in the report:

    ReportMemo: Left([MemoField], 500)

    will give you the first 500 characters. Adjust to suit.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "apollo8359" <apollo8359@discussions.microsoft.com> wrote in message
    news:5B5D5341-460E-4415-AED9-90EE7B5367A7@microsoft.com...
    > I have some users who are budding authors generating large memo fields.
    > Because I have to run the report in landscape it reduces my page length

    for
    > the expanding field. When the text box width is big enough for the entire
    > memo to fit on one page it works, otherwise it hangs. I don't want to
    > restrict the memo field, just cut off the output in the report. So, is

    there
    > a way to limit the text box length of a growing memo field only in the
    > report? Thanks.
     
  5. apollo8359

    apollo8359
    Expand Collapse
    Guest

    Thanks to both Arvin and John. I guess I was so focused on modifying the
    report that I forgot I could modify the query feeding the report. Your
    solutions worked great and the report is on its way.

    "Arvin Meyer [MVP]" wrote:

    > Sure. Use a query as the recordsource for the report. Add a column for use
    > in the report:
    >
    > ReportMemo: Left([MemoField], 500)
    >
    > will give you the first 500 characters. Adjust to suit.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "apollo8359" <apollo8359@discussions.microsoft.com> wrote in message
    > news:5B5D5341-460E-4415-AED9-90EE7B5367A7@microsoft.com...
    > > I have some users who are budding authors generating large memo fields.
    > > Because I have to run the report in landscape it reduces my page length

    > for
    > > the expanding field. When the text box width is big enough for the entire
    > > memo to fit on one page it works, otherwise it hangs. I don't want to
    > > restrict the memo field, just cut off the output in the report. So, is

    > there
    > > a way to limit the text box length of a growing memo field only in the
    > > report? Thanks.

    >
    >
    >
     

Share This Page