Formatting a percent bar in a report and/or continuous form

[accessbro]

I have a query that calculates the planned cost for contractors. I used a custom workdays function to calculate the workdays between the contract start and end dates then I multiply by 8 (hours per day) and the contractor rate to get the planned cost. I have another query that pulls all the contractor's timesheets that fall in between the contract start date and contract end date and totals the hours worked. I have another field that calculates the workdays between the contract start date and end date and I multiply it by 8 and the rate to get the actual cost to date. I divide the planned cost by the actual cost to date to get a percentage spent. How can I format the textbox to shade in the percentage spent?

[RuralGuy]

It should probably work just like a progress bar. http://www.accessmvp.com/JConrad/acc...gressbars.html