Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2017
    Posts
    12

    Question Only display part text ona report

    Hi



    The database I am replacing for work shows 4 lines of job updates where we delete the oldest to add the newest each week. It is done this way so that we can print reports and have a controlled amount of information. I'm wondering if its possible to have an unlimited text box where only the last 4 lines of text show up on a report. Is this possible and if so how?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the query of the report, make a field that shows only the last N characters...say 100.

    EndText: right([field],100)

  3. #3
    Join Date
    Mar 2017
    Posts
    12
    so simple yet magnificent. thank you

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-18-2016, 04:50 PM
  2. Changing the Numerical Display Part 2
    By Thompyt in forum Programming
    Replies: 1
    Last Post: 01-07-2016, 12:55 PM
  3. Replies: 6
    Last Post: 06-25-2014, 11:58 AM
  4. Why doesn't RTF text display properly in report?
    By kenton.l.sparks@gmail.com in forum Access
    Replies: 1
    Last Post: 05-02-2012, 07:30 PM
  5. Replies: 1
    Last Post: 01-10-2012, 12:06 AM

Tags for this Thread

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