Hopefully another quick & easy one

[gussy]

Hi folks

In a text field on a report, I want to be able to format the text so that I can add text to the field's 'incoming' text. (the field is text, not numeric)

ie, in this instance I want to add the letter 'p' before the number that is contained in the field. (refers to page number)

So the field in the report becomes : p"value"

I can do it in Excel, using "p"### , but I don't seem to be able to in Access, despite trying every damn combination.

Is it in the 'format' property, and if so how?

Thanks in anticipation.

 

[Rich]

="p" & [MyField]

 

[gussy]

Forgive me for being thick....

I tried that in the Control Source property, but didn't seem to work...

Is that the right property, or should it be in the Format property?

 

[gussy]

Nope cancel that, I'm thick. I've cracked it thanks for the help!