Results 1 to 3 of 3
  1. #1
    bucgatorfan is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    3

    Report object manipulation


    I would like to show a percentage-like bar (a colored box, set to a varying length) to the right of each record line in a report. The box should change size and position based on the values in the row it is on.
    I placed a box in the detail section of the form and I can get it to change size and location, but it is repeated in every row to reflect the currently selected row. Is there a way to "bind" the box displayed in each row to the data displayed in that row?
    Last edited by bucgatorfan; 03-28-2018 at 02:28 PM. Reason: Changed form to report

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    How are you getting it to change size and location? Post your code. Did you place code in report Detail section Format event? This code will only execute when report opens in PrintPreview or direct to printer.
    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
    bucgatorfan is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    3
    Wow. I had the code in the Report's Open event. Moving it to the detail's Format event is exactly what I needed. Thank you.

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

Similar Threads

  1. New record manipulation in a form
    By Al Catraz in forum Programming
    Replies: 1
    Last Post: 04-09-2013, 12:09 PM
  2. Replies: 3
    Last Post: 04-23-2012, 12:06 AM
  3. Form output data manipulation
    By bearsgone in forum Forms
    Replies: 1
    Last Post: 04-05-2011, 04:21 PM
  4. Form manipulation error
    By witooldas in forum Forms
    Replies: 6
    Last Post: 03-18-2011, 02:40 AM
  5. Form Manipulation examples
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-24-2010, 12:03 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