Welcome to SPN

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

Sign Up Now!

Why does Access truncate memo fields in a report?

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

  1. prph

    prph
    Expand Collapse
    Guest

    I have a table with a memo field. When I run a query on the table and view a
    report, the memo field data is truncated. I've reviewed all settings and
    can't seem to figure out why all of the memo field fails to display. Data in
    the memo field of my table is complete but it doesn't display in the report.
    Any thoughts ?
     
  2. Loading...

    Similar Threads Forum Date
    Buddhism Why Does Buddha Have A Jooda? Interfaith Dialogues Nov 29, 2014
    General Why does Caste still Persist with Sikhs? Hard Talk Jul 31, 2012
    General Why Does SPN Publish Third-Party Advertisement? Hard Talk Jul 15, 2011
    Why Interfaith Dialogue Doesn't Work - What We Can Do About It Interfaith Dialogues May 30, 2011
    Confucianism Who was Confucious and Why Does it Matter? Interfaith Dialogues May 23, 2011

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    prph wrote:
    > I have a table with a memo field. When I run a query on the table
    > and view a report, the memo field data is truncated. I've reviewed
    > all settings and can't seem to figure out why all of the memo field
    > fails to display. Data in the memo field of my table is complete but
    > it doesn't display in the report. Any thoughts ?


    Is the control large enough to display all the data? Is the grow
    property set to yes?

    --
    Joseph Meehan

    Dia duit
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    See:
    Truncation of Memo fields
    at:
    http://allenbrowne.com/ser-63.html
    for a list of the issues that cause this problem, and how to work around
    them.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "prph" <prph@discussions.microsoft.com> wrote in message
    news:100D1D3D-5F16-4E17-B536-A56CFB0D3EBB@microsoft.com...
    >I have a table with a memo field. When I run a query on the table and view
    >a
    > report, the memo field data is truncated. I've reviewed all settings and
    > can't seem to figure out why all of the memo field fails to display. Data
    > in
    > the memo field of my table is complete but it doesn't display in the
    > report.
    > Any thoughts ?
     

Share This Page