How to convert numbers to thousands dynamically in field

  • Thread starter Thread starter toddmanqa
  • Start date Start date
T

toddmanqa

Guest
Hello.

Does anyone know how I could create a field where a user could enter in a number, but the number would be displayed in thousands.

For example, if the user typed in 78, the field would display 78,000 and that value would be recorded to the table?

Thanks,

toddmanqa
 
Could you use something like the following tin the after update event of the first text box:

me!mytextBox2 = me!myTextBox1 * 1000

???
kh

BTW: I wouldn't store 78 and 78,000, just one or the other...
 

Users who are viewing this thread

Back
Top Bottom