Displaying a percentage in a control

[Blings]

I'm struggling to display a percent in the Discount % control which is pulled from the Supplier profile. The value should be 2.5%

[Minty]

Try formatting the control source
=Format([Discount],"Percent")

[CJ_London]

or just set the format property to percent

[Welshgasman]

Hasn't the o/p done that, just that they are likely storing .25?

[CJ_London]

so they are - but if that was the case, you should still see the % char. So now I suspect the value is a text value rather than numeric. Wait to see what the OP comes back with. Perhaps the box in orange should be formatted as well

[Welshgasman]

I am even more puzzled now as the source is another control on the same form? Why not just use that source?

[Minty]

It's to fool the natives...

[Welshgasman]

Well it worked for me.

[Blings]

Try formatting the control source
=Format([Discount],"Percent")

After testing that access throws the code out like this ""=For"m"at(["d\isc"ou"n"t],Percent)"

[Blings]

so they are - but if that was the case, you should still see the % char. So now I suspect the value is a text value rather than numeric. Wait to see what the OP comes back with. Perhaps the box in orange should be formatted as well

The box in orange is formatted as Percent, however, the value is 0.025 when it should be 2.5%.

[Blings]

I am even more puzzled now as the source is another control on the same form? Why not just use that source?

The process behind the logic is when a Supplier is picked, the orange blocks are updated and in return the visible white controls to the left display the values for the user.

[Blings]

Well it worked for me.

What did you do? I'm still struggling to get it to display 2.5%.

[kd2017]

so they are - but if that was the case, you should still see the % char. So now I suspect the value is a text value rather than numeric.

Agreed. OP, double check that the datatype for wherever 0.025 is coming from isn't a string. Playing around with this on my end I could only duplicate your results when the source was a string. I suppose if you had to you could use CDbl() in your Text17 control source

The process behind the logic is when a Supplier is picked, the orange blocks are updated and in return the visible white controls to the left display the values for the user.

I'm still not clear on why you need two text boxes here.

[Blings]

tblSuppliers
* DiscountPercentageID = Number

tbluSuppliersDiscount
* DiscountPercentage = Number

[Welshgasman]

What did you do? I'm still struggling to get it to display 2.5%.

That was in reply to post 7