Leading text for a bound textbox

[volorgas]

I have a report that I would like to add a bound textbox to. But, I would like this bound textbox to always display some text before the value of the relative field is displayed. Here is an example.

"Photo courtesy of" precedes the value of the field ([PhotoBy]) in a bound textbox.

How can I achieve this? Thanks in advance.

 

[Accessme2]

volorgs,
="Photo courtesy " & me.PhotoBy
that should do it

 

[boblarson]

In the controlsource of the text box put:

="Photo courtesy of " & Me!PhotoBy

 

[boblarson]

Oh, and by the way:

 

[Rich]

volorgs,
="Photo courtesy " & me.PhotoBy
that should do it

Me. or Me! is a VBA function and will not work in the control source of a textbox

 

[boblarson]

In the controlsource of the text box put:

="Photo courtesy of " & Me!PhotoBy

Yes, I wasn't thinking straight it should just be

="Photo courtesy of " & [PhotoBy]

 

[volorgas]

I tried ="Photo courtesy of " & [PhotoBy] and that didn't work. The report displayed #Error instead of what was intended. Thoughts?

 

[Accessme2]

make sure you change the name of the textbox. if you have the name and Control Source with the same name you would get and error.

 

[volorgas]

All is right with the world. Thanks everyone!