troubles with number field with percent format!

  • Thread starter Thread starter Arsim
  • Start date Start date
A

Arsim

Hi Everybody,

I have troubles with field formated as percent. Working with TAB, when
selecting that rov where should be number in percentage and when
typing e.g 0.2 (without using % mark)it returns 20.00%.
Is there any possibility, to forcve MS access to accept exact typed
number in formated percent field. also in case when typing 1 it
returns 100% or something like that.

I will apriciate if anybody can help on this issue.
 
Arsim,

When the field is formatted as percent, it automatically displays the number
as a percent, where 1 = 100%, 2 = 200%, .2 = 20% and so on. If you want to
see the numeric value 1, 2, .2 then get rid of the formatting.

Dale
 
Back
Top