report - percent format display

[parthis]

Hi,
I am new to Access and working a Report to display a Percentage value.
The value in db is a text type with value 23

But when i apply Format = Percent in design view of Reports it renders it as 2300.00% while the expected is 23.00% . Please help me with this.

 

[boblarson]

Hi,
I am new to Access and working a Report to display a Percentage value.
The value in db is a text type with value 23

But when i apply Format = Percent in design view of Reports it renders it as 2300.00% while the expected is 23.00% . Please help me with this.

If you use the built in "percent" format then it expects the value to be stored as .23 and then it will display properly. If you just want to display it as a percent the way you have it, try this:

in the controlsource of the text box on the report use:

=Format([YourFieldNameHere],"0.00%")

 

[parthis]

Still It displayes the same format.2300.00%

=Format([AE_POCRate],"00.00%")

Above is the expression used.

I dont think i am wrong here. Looks weird

Is there something else that i can do just to display correct percentage format and not store in table.

 

[boblarson]

Still It displayes the same format.2300.00%

=Format([AE_POCRate],"00.00%")

Above is the expression used.

I dont think i am wrong here. Looks weird

Is there something else that i can do just to display correct percentage format and not store in table.

Then the simplest is to use:

=Format([AE_POCRate]/100,"percent")

 

[parthis]

i tried this and working. But i wonder why the format function whose purpose is to display as ##.##% is not working as expected. Is it a known thing? Anyway thanks. It helped