bound text box with percentage

[zezo2021]

Hello

I have textbox on a form bound to a table

when changing the format to percent

it display number 17 to be 1700%

I want to show it as 17%


thank you

 

[Mike Krailo]

When there is no Formatting applied, your value in the text box should be 0.17. Is that the case?

 

[zezo2021]

17

When there is no Formatting applied, your value in the text box should be 0.17. Is that the case?

 

[Mike Krailo]

That's your problem then, it should be 0.17 to yield 17% with Formatting.

 

[arnelgp]

if the number is Readonly, you can add another Unbound field and display the Correct percent value.
the ControlSource is:

=[theOriginalField] / 100

now, apply Percent format to this unbound textbox and hide the Original textbox.

Or you can create a Query with new Calculated column (same as the above with Percent format) and use the Query on your form.

 

[zezo2021]

if the number is Readonly, you can add another Unbound field and display the Correct percent value.
the ControlSource is:

=[theOriginalField] / 100

now, apply Percent format to this unbound textbox and hide the Original textbox.

Or you can create a Query with new Calculated column (same as the above with Percent format) and use the Query on your form.

can I use a custom format?

###.000

the textbox is bound to the table and the user enter data inside this textbox

 

[arnelgp]

can I use a custom format?

you can ofcourse:

##0.00

 

[zezo2021]

you can ofcourse:

##0.00

converted the format to fixed

and the number still
17

thank you