Change Percentage Data Type

[jo8701]

Hi I use Access 2003

Ive set the Data Type on a field name to = Percentage
Ive tried to use all - Field size types



I want to enter in 50 in the table and have the output be 50%
currently it goes to 5000%

Is there anything i have to add in the Validation rule to make it show the exact value?

Could some one kindly tell me a solution as i've tried a few methods none seem to work :-(

[aytee111]

That is what Access does with the Percentage format. You will have to create a custom format in the way you want it to appear.