Textbox Help

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a Report that is using a query for it's source.
I want to take 2 fields like, firstname and lastname, and
put them both into one textbox. How can I do this?

The setting on the textbox only allows one source. I am
guessing I will have to add code somewhere on there that
will accomplish this but I have no idea what to do.

Thanks ahead of time,

Chris
 
Hi Chris

in the query in a blank column type
fullname: [firstname] & " " & [lastname]
this will give you a new field with the concatenated (yep, that's what its
called!) name.
you can then use this as the source for your text box control.

Regards
JulieD
 
Back
Top