Adding a Character after a ControlSource 1

[sanders720]

I have some reports where I would like to an a "B" after the controlsource. In other words, if the controlsource SubAssy field is 100, I would like the report to generate a 100B. Can the control source be modified to accomodate this? Or is there another very simple way?

Thanks in advance for the help!

 

[mrathi]

In the control source property do the following:

=[SubAssy] & "B"

 

[sanders720]

Thanks!