Add comma during currency field entry

[dbguru316]

I would like to be able to have comma's appear during a currency field entry.
They appear after the currency is entered, but want them to appear as the
currency value is increased by each thousands places, during entry.

Example
100 shown then when adding the next 0, it shows 1,000, then 10,000, then
100,000, the 1,000,000, etc.

Input mask does not work with currency formatted fields. This seems like a
simple request, but can't find the solution...

 

[John Nurick]

Trust me, it's not simple.

You'll need to muck around with the textbox's contents in its Change
event procedure and it probably won't be easy to get it working fast and
reliably enough not to irritate users.