Format A User Form Text Box As Currency Or A Percentage
June 23, 2021 - by Bill Jelen
Challenge: You are building a custom user form to calculate a monthly payment, based on loan amount, number of payments, and interest rate. You would like one text box on the form to be formatted as currency and another to be formatted as a percentage. There do not appear to be a properties to format the text boxes.
Solution: You can use the BeforeUpdate code to grab what the person types into a text box and format it properly. If someone types 20, you can have it automatically change to 20% when the user tabs out of the field.