How can I make a form accept percentages as Excel does?

[Guest]

In excel, once I've formatted a number as a percent, I can enter 5.3% as "5.3".

In my access form right now, I have to enter ".053" to get 5.3%. Is there
any way to do this?

Bonus question....In a different field, I'd like to enter a number in
thousands, but have it stored as the actual number. (ie enter 1000 for 1
million, but store the number 1000000.)

Thanks in advance.

 

[Guest]

Add a macro in the After Update line that sets value of your control, call it
percentage, to percentage/100

 

[adsl]

In excel, once I've formatted a number as a percent, I can enter 5.3% as
"5.3".

In my access form right now, I have to enter ".053" to get 5.3%. Is there
any way to do this?

Bonus question....In a different field, I'd like to enter a number in
thousands, but have it stored as the actual number. (ie enter 1000 for 1
million, but store the number 1000000.)

Thanks in advance.

 

[adsl]

Add a macro in the After Update line that sets value of your control, call
it
percentage, to percentage/100