I have a report Question, help appreciated

[brian0721]

I am really new at access, so this might be a stupid question. Anyways, I have a report and one of the "fields" that i had created was for a name. I need this name to automatically appear at a certain place. Normally this is not a problem, except this time it is in the middle of a paragraph. I tried just moving the "field" but since it is inside a label it wont work! What do i do?

 

[GlennL]

I always do it in the following way, although there may be easier ways...

Place a text box into the report and type your paragraph thus:

='this is a paragraph of text containing the field'&' '&([fieldname])

That should do it.

 

[DJ7T]

or, easier, put the trailing space in the original quote set, as such:

='this is a paragraph of text containing the field '&([fieldname])