Enter currency from right position in MS Access Form

Copper Contributor

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!

0 Replies