Hello, I'm working on a database Form where the user wants to enter currency for purchases in a hobby shop. They would like to enter it numerically only, starting in the second decimal (i.e. penny) position, and then filling from right to left - that is, if I entered 7,8,9, it would display like this:
I have been fiddling with input masks and the SelStart command in VBA. I can get it to start at the penny position if I have the right input mask / SelStart combination, but I can't get it to start filling across from right to left. I've seen this functionality on my bank website but I don't know how to make it happen here. Please let me know if you have any suggestions. Thanks!