Put text box in label...

[brian0721]

How can I do this. I have a label that I type information into. In the middle, I want to insert some information from a text box on a form. Is there a way to do this without having to put an actual text box in there with the label or something, because that is a big pain.

Thanks a ton!

 

[Rich]

It's no more difficult to add a text box than it is to add a label. if you don't want the label that comes with the text box just delete it.

 

[brian0721]

It's no more difficult to add a text box than it is to add a label. if you don't want the label that comes with the text box just delete it.

I guess I said that wrong. Here is what I want. I have a form that the user enters information. Then on the report it has standard text, for example, the report might say: "The borrower on this loan is" then I want the field from the form with the borrower's name to show up next, then after that there is more text "They have been..." So it will look like this: "The borrower on this loan is (borrower) they have been.." However, I am not sure how to do this...

Any advice?

Thanks a ton!

 

[Rich]

So is the users name going somewhere in the middle of say a memo field that's just been typed, or is it standard text?

 

[brian0721]

So is the users name going somewhere in the middle of say a memo field that's just been typed, or is it standard text?

The name is going in between some standard text. The form will be used for each person, but the name will be different for each one obviosuly. But I want the spacing and everything lining up to look ok too.

Make sense?

 

[RichO]

In the control source for the text box:

="The borrower on this loan is " & [borrower] & ". They have been..."