Percentage

[Amour]

Hi I am new to Access.

Thank You for any help.

I have this field MilAmt and I changed it to numbers from text within the
tblTravel. And also to percentage within format, the dec position is set to
3. When then user types and then press the tab key it replaces with zero's.
But before it was working only not with a percentage look. What it looked
like before was 0.455 and what I want it to look like is .455%.

Please help and thank you!

 

[Rockn]

0.455 is not .455% it is 45.5%
If you want the text box to be displayed as a percentage set its properties
for format to be percentage.

 

[Amour]

Thank you for your response... I guess I was not to clear. This field use
to be a text field (on the table) also textbox (on the form) and when I try
to set the format as a percentage nothing comes up under the pull down. So I
turned this field into a number (on the table). Then I was able to enter in
the percentage (under format), but now the field will not take changes.

Example: user types in 0.455 presses tab key and the field changes to 0.00

What could I be doing wrong...

Thank You for any help..

 

[John W. Vinson]

Thank you for your response... I guess I was not to clear. This field use
to be a text field (on the table) also textbox (on the form) and when I try
to set the format as a percentage nothing comes up under the pull down. So I
turned this field into a number (on the table). Then I was able to enter in
the percentage (under format), but now the field will not take changes.

Example: user types in 0.455 presses tab key and the field changes to 0.00

What could I be doing wrong...

Sounds like you may have created the field in your table as the default Number
datatype, which is Long Integer. Integers are by definition whole numbers, and
will not let you enter fractions.

Change the field's size property (in the lower left of the screen in table
design view) to Double and you'll be able to enter fractions.

John W. Vinson [MVP]