Add Percentage sign to a text field without changing value (1 Viewer)

[l.kyriazakos]

Dear Experts,

I am trying to add a percentage sign (%) after a number I get from a table, thus the number 1,5 should display 1,5% and NOT 150%.

I am using the Format Property of the text field.
I tried #,##% which converted the value to a percentage (1,5 became 150%)
Then I tried #,##"%" and #,##\% Access ignored both and changed the value in the property field to #,##%

Using the Format function is not an option because it is a bound field which should be editable.

Any Help is appreciated.

Regards

 

[plog]

If it is to be editable, just put a caption after it that holds the percent sign.

 

[Simon_MT]

Try this:

="Less " & CCur([Discount Percent])*100 & "% Discount"

Simon

 

[l.kyriazakos]

I solved it as Plog recommended.
I added a caption after the field containing a % sign