Results 1 to 4 of 4

Display a percentage indicator in a field.

  1. #1
    Chris6789 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    7

    Display a percentage indicator in a field.

    Hi, is there anyway to display a percentage indicator in a field when you enter a percentage?
    I´m using the task manager template, and where you enter a percentage in the ´complete´ column, I want it to show a bar like the battery percentage indicator on a phone.
    Is this possible?


    Thanks very much.

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,082
    providing this is not a continuous form or datasheet then do the following

    create a rectangle control (called indOuter) with a border the size you want the bar to be (with or without background, up to you)
    create another rectangle control (called indInner) without a border but with a background which (assuming this is a horizontal bar) fits just inside the the first control and located to the left

    in an event which triggers a change in the percentage value (lets assume the user enters this manually), so the percentage control afterupdate event put

    me.indInner.width=me.indOuter.width*me.percentage

  3. #3
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    1,913
    https://support.office.com/en-ie/art...f-c49890667513
    That's built into Access conditional formatting. Have a look at the website above.

  4. #4
    Chris6789 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    7
    Thanks very much, I´ll try it when I return to work tomorrow.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-18-2018, 07:44 AM
  2. Toggle button/indicator for mutually exclusive event
    By Rufusdisturbed in forum Access
    Replies: 6
    Last Post: 03-20-2017, 05:22 AM
  3. Replies: 3
    Last Post: 08-25-2015, 02:26 PM
  4. Replies: 3
    Last Post: 12-10-2013, 12:55 PM
  5. Replies: 5
    Last Post: 08-15-2011, 07:12 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
  •  
Tech Forums: Microsoft Office Forums