How do I: Enter a Percent, Record a Decimal

[gaffonso]

I've got a text box that maps back to a decimal field data type in SQL Server (in an Access Project).

I'd like to offer the user the ability to type in an integer from 0 - 100 (the percent they desire) and have that be translated into the corresponding decimal value.

I can do this with code but I was hoping there was a more straightforward way to get there. Input Masks, maybe?

Thanks!

- Gary

 

[Craig0201]

Add a hidden text box on the form. Bind this to the data source holding the decimal. Unbind the other field. Set the control box of the hidden field to be the value of the first field divided by 100.

HTH

Craig