Showing % Sign in Access

[jo8701]

Hi,

This is prob a simple query (i hope :-))

On one of my fields within a processing table i am trying to default the data type to show a % sign when a value is enterd without manipulateing data eg user enters 50 shows as 50%

What currently happens is user enters 50 turns into 5000% is there a way i can counter this i have tried to enter different formats but nothing seems to change this.

THank you

[RuralGuy]

You need to divide by 100 to get the proper value, which I'm sure you know.

[jo8701]

Perhaps im being a bit thick but when i try and ammend this it wont work? what do i type into the Format bit in properties do make it show 50% as 50% rather than 5000%

[RuralGuy]

...and if the user types in .5 what do you do?

[dodo47]

Hi
if you declare a field as percentage, access wait for:

A
----- / 100
B

Not

A
-----
B

So, declare integer-double your field and use a label near your form field with "%"

regards