Forum Discussion
tonyv
Dec 13, 2018Copper Contributor
Enter currency from right position in MS Access Form
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:
first .07
then .78
finally 7.89
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!
No RepliesBe the first to reply