Results 1 to 4 of 4
  1. #1
    gregs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    2

    Report formatting can grow options causing other values to move too

    I have a report the shows ingredients that can vary in length and I used to append the allergens to the end, of the ingredients, so they appeared right after the end of the ingredients. I want to bold the allergens but not sure how to do that. If I make it a separate field I am not sure how to make it appear right after the end of the ingredients if I make it a separate field after the ingredients. When I make the Ingredient field shorter and set to can grow when it grows it also moves fields to the left of it down. How can I stop the other fields from moving?


    Click image for larger version. 

Name:	MSaccess_Report_CanGrow.PNG 
Views:	6 
Size:	19.2 KB 
ID:	37426

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If the text format property is set to Rich Text you can use HTML code in it. Like

    =[IngredientsField] & "<br><b>" & [AllergensField] & "</b>"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    gregs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    2
    Thank you pbaldy. That is a great tip that I did not know you could do. That worked. I had just created a sub report and put the ingredient and allergen there by themselves. I like your way better. :-)

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 24
    Last Post: 08-15-2018, 06:57 PM
  2. Replies: 7
    Last Post: 04-16-2018, 07:43 PM
  3. Can Grow in Report
    By gatsby in forum Reports
    Replies: 7
    Last Post: 03-22-2015, 10:55 AM
  4. Replies: 2
    Last Post: 12-10-2013, 04:23 PM
  5. Replies: 1
    Last Post: 09-25-2013, 10:33 PM

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