Calculate a Percentage-Based Budget in a Microsoft Access Form
Question details
Calculate a budget in an Access form from an actual amount and a user-entered percentage increase.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user wants to enter a percentage increase on a form and see the resulting budget for an actual amount.
- Observed behavior
- The form should calculate a budget of 55 when the actual amount is 50 and the increase is 10%.
Confirm that the form's record source includes the Actual field and that Actual uses the Currency data type. If you need to save the percentage, add a Number field named PercentIncrease with its Field Size set to Double.
Calculate the budget in an Access form
Use a percentage input and a calculated text box to display the budget without storing a duplicate calculation.
In the Navigation Pane, right-click the form and select Design View. Confirm that it has a text box bound to Actual.
Add a text box and name it PercentIncrease on the Property Sheet. Set its Format property to Percent. To save the percentage with each record, set its Control Source to the PercentIncrease field; otherwise, leave the Control Source blank.
Add another text box, name it CalculatedBudget, and set its Control Source to =[Actual]*(1+[PercentIncrease]). Set its Format property to Currency.
Switch to Form View, enter 50 for Actual and 0.1 for PercentIncrease, then move out of the percentage box. The percentage should display as 10% and CalculatedBudget should show 55 in the configured currency format.

Plan Percentage-Based Budgets in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and support for Microsoft Office formats, making it easy to move spreadsheet-based budget work. It does not replace or repair Microsoft Access forms.

Frequently Asked Questions
How should I store a 10% increase in Access?
Use a Number field with Field Size set to Double and store 10% as 0.1. Set the form text box's Format property to Percent to display it as 10%.
What expression calculates the budget from Actual and PercentIncrease?
Set a calculated text box's Control Source to =[Actual]*(1+[PercentIncrease]). For an Actual value of 50 and PercentIncrease of 0.1, the result is 55.
Will the calculated text box update my existing Budget field?
No. A text box with a calculated Control Source displays the result but does not save it to the Budget field. You can calculate the value in the form or a query when needed.
Why is the budget calculation blank?
Check that Actual and PercentIncrease contain values and that the expression references the correct control or field names. A null input produces a null result in the calculation.




