Results 1 to 4 of 4
  1. #1
    bfruge is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    9

    Customize Text Display for Reports


    I have a list of items that users select when filling out a form. They are labeled with a numerical code for sorting purposes for our reports. Ex: 01-Youth Small Shirt, 02- Youth Med Shirt, etc. They are coded to put them in a custom sort order for me. The issue is that when they display on the report, they are displayed with the code in front, which looks like a qty. Ex: 05-Adult Med is only 1 adult med shirt, not 5 shirts. I would like to change the display text for these list items to Just the Text part, omitting the numerical part. I have found some info regarding formatting the number of characters, but all of them have different #of characters, so that would not work for me. So, in short, on my report, I would like 01-Youth Small to display as Youth Small. 02-Youth Med as Youth Med. etc.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    This is why discrete data should be in separate fields, not jammed into one. It is easier to concatenate than parse.

    Expression in textbox using string manipulation functions to parse:

    =Mid([fieldname], InStr([fieldname], "-") + 1)
    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.

  3. #3
    bfruge is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    May 2018
    Posts
    9
    I receive a circular error when using that expression. Field name is UDExhibitor-List2. Expression is =Mid([UDExhibitor-List2], InStr([UDExhibitor-List2], "-") + 1)

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Name textbox different from field, such as tbxUDE. When you do this, the expression will change to the new textbox name and have to edit it back to using field name.

    Advise not to use punctuation/special characters in naming convention.
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 03-20-2019, 12:08 PM
  2. Replies: 8
    Last Post: 03-18-2016, 11:02 AM
  3. Replies: 9
    Last Post: 04-18-2014, 08:51 PM
  4. Replies: 1
    Last Post: 02-03-2013, 10:43 PM
  5. Display images in reports
    By pmregan in forum Reports
    Replies: 4
    Last Post: 07-20-2010, 02:49 PM

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