I would like to present progress bars on a report. Each row would have a box that would vary in width depending on the percent complete the corresponding project is. Any way to do this?
Advanced Beginner
Windows XP 
Access 2007
I would like to present progress bars on a report. Each row would have a box that would vary in width depending on the percent complete the corresponding project is. Any way to do this?
Administrator
Windows 7 64bit Access 2010 32bit
I'm sure there is but have you considered using a Bar Chart in your report?
Novice
Windows XP Access 2003
With a textbox named tbProgress bound to the field containing your progress as a percentage % (Give the text and the background the same color if you wish) you can simply use in the details format event:
Where 500 is your "full" width (100%) bar. You should probably store this as a constant in your reports module.Code:Me.tbProgress.Width=Me.tbProgress*500
With VB, how can you get the DB file size?
Database Size
Posting Permissions
Reply With Quote