Concatinating Percentage to Controlsource

For a control, I don't want to use the Format called "Percent".  Instead I want to concatinate "%" onto this controlsource code (only if the value is over 0).


How can I modify this syntax to put a percentage sign on the end of the value displaying on the report?
Who is Participating?
peter57rConnect With a Mentor Commented:
You can't add a % symbol to a field if it's defined as a number except through using a percent format.

If you want to add your own % symbol you must define the field as text - but of course it then can't be used directly as a number in calculations.
Why not just add a label control to the right  of the textbox that just contains the % symbol.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.