Include Text in text box with the field

[TinaCa]

This used to be really easy. I have a text box bound to a field and I am trying to put text in the field also. The code I've been trying to use is in the text box is:



[crewname]& "Payroll Detail"

I am getting a syntax error. This used to be really easy - what did they change now?

[boblarson]

If the text box is bound to the field then you have to have the field ONLY in the control source - [crewname]

To store both in the table you can use the form's BEFORE UPDATE event to append the words to it but why would you be wanting to add that anyway?

[TinaCa]

I copied the code for the page number and inserted my text and the field name. I know cheating but it worked so it looked like this:

="Payroll Detail" & [crewname]

Thanks Bob you always come through.