Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171

    Looking for alternative to the Memo field or Text field for a Comments field

    I have database ready to roll next week but we have run into an issue with one field. I need a Comments field that can be in my table and display on forms and reports.

    I originally set it up as a Text field but that is limited to 50 chars. I changed it to a memo field and the Comments show up correctly on the forms but it is displaying special characters on the Reports.

    Any suggestions.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    A text field is 255 char. There is nothing wrong with using a memo field, that is best way to go for comments. Using them on reports is not a problem, the issue must lie somewhere else.

  3. #3
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    Any idea what would cause the special characters on the report? Any ideas on where to start? I don't think it is a table issue since it displays on the datasheet and forms correctly. It is only in the reports that I am getting the special characters.

    Does Plain text or Rich Text make a difference?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Grasping here - what is the font? I've never used Rich Text so maybe yes.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I received a warning when changing the field to Rich Text on a report that data that is not valid HTML will not be displayed.

  6. #6
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    Calibri 10 Plain Text. I got the same error when I tried to change to Rich Text and decided against it.

  7. #7
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Does it happen in all the views of the report?

  8. #8
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    Yes. Only in the views of the reports.

  9. #9
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    There are 4 different ways to view a report, I was asking if it happens in all of them.

  10. #10
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    It happens in Report View and Print Preview and when I save it to Adobe. Not sure what other ways there are to view. It wouldn't show in Design View since there is no data.

  11. #11
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I'm running out of ideas! could you post a database, with just the table and report? You can remove fields with confidential data.

    What I would do, maybe you can try, create a new report using the wizard with just the comments field. See if you get the same results.

  12. #12
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    After some research it appears to be a known bug in Microsoft. You can't use a Group By in a query. If says to change it to First. Tried that and it didn't work so I am playing around with it. They also recommend doing a Compact and Repair which I have done and it did not help. Last suggestion was to delete and recreate the query.

  13. #13
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    It isn't a bug, you have never been able to do a Group By on a memo field. Put the memo field on a subreport and link it.

  14. #14
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    The memo field is on a subreport which runs from a query. What do you mean by Link it?

  15. #15
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    Here is the query for my subreport. The memo field is ContractorComments.
    Attached Thumbnails Attached Thumbnails Subreport Query.PNG  

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-07-2015, 07:49 AM
  2. Adding date stamp to form comments memo field
    By mikehorse in forum Forms
    Replies: 3
    Last Post: 09-18-2014, 12:30 PM
  3. Replies: 9
    Last Post: 07-21-2014, 11:57 AM
  4. Change Text field to Memo Field in a Query
    By Yarbz in forum Queries
    Replies: 5
    Last Post: 06-28-2012, 05:24 PM
  5. Replies: 5
    Last Post: 06-19-2012, 10:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums