Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Memo Field (2K and XP)

    Edited by HansV to provide links to posts - see <!help=19>Help 19<!/help>

    Greetings: I have a report that is printing a memo field. However, only 255 characters of the field print. How can I get the entire field to print? I posted this earlier (<post#=551895>post 551895</post#>) and received a reply from Wendell (<post#=551899>post 551899</post#>) stating that trying to format the field or sort on the field would cause this. However, this is not the case this time. Just trying to print. Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Memo Field (2K and XP)

    Does this happen only when printing the report to paper, or also in print preview?

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Memo Field (2K and XP)

    Both in Preview and Hard Copy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Memo Field (2K and XP)

    I would still suspect some kind of formatting or sorting on the memo field, either in the report itself or in its record source.

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Print Memo Field (2K and XP)

    Some time ago I encountered a similar problem and discovered that if the query behind the report uses 'distinct' (or has the UniqueValues query property set to Yes ) the memo fields are truncated at 255 characters.

    Here is Knowedge Base article
    Regards
    John



  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Memo Field (2K and XP)

    Database attached. The report is selected using the form. CDBG is the selection in the dropdown. memProgramNotes is the field in question. Thanks again
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Memo Field (2K and XP)

    Hey John, Thanks for the reply. That was the case in this problem. DISTINCT was removed and the query and report seem to be functionally properly. Thanks again. Thanks for the referenced article also.

  8. #8
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Print Memo Field (2K and XP)

    I see that you have just posted the db, and the query does indeed use "distinct".

    My workaround was to remove the memo field from the query, and use a dlookup as the control source for the control on the report.

    Are you clear about whether you need to keep the Distinct. I have not studied the logic of it enough to work this out myself.
    Regards
    John



  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Memo Field (2K and XP)

    I'm not entirely sure how DISTINCT shows up in queries. I know that I don't explicitly put it in. I'm curious as to how a dlookup would work on this, if you don't mind.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Memo Field (2K and XP)

    Normally, the DISTINCT keyword is set by setting the Unique Values property of the query to Yes.
    In your query, Unique Values can be set to No without making a difference with respect to the returned records, since there is only a single record for a given program and year in tblAccomplishments, tblProgramExpenditures and tblProgramsNotes. If there would have been multiple records for a program and year in one of those tables, the situation could have been different.

    Using DLookup, the control source of the notes text box could have looked like this:

    =DLookUp("memProgramNotes","tblProgramsNotes","int ProgramID=" & [intProgramID] & " AND intYear=" & Forms!frmProjectYear!intProjectYear)

    To make this work, you must add the intProgramID field from tblPrograms to qryActivitiesFundingObjectives.

  11. #11
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Memo Field (2K and XP)

    Thanks Hans, If the removing of DISTINCT causes additional problems, I'll give this a go.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •