Combining Multiple Table Columns Into A Single Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Rick B" wrote:

not sure how to do it with the expression builder, but if you are creating a
form, report, or query....
create an unboud text box and enter the following (edit for your field
names)...

=[FirstName] & " " & [LastName]

=====

Im trying to use this method and its not working. :(

Mine would look like this ...

=[Nombre] & " " & [ApellidoPaterno]

I always get an error ['#Error'] message on the field when looking at the report.

I have a table which stores all the data. A form, where users will enter the data. And a report, which is used to print what users entered via the form. On the form I added a command button that when pressed prints the report. Everything looks fine except the name cause Im trying to combine both First Name [Nombre] and Last Name [ApellidoPaterno] which are stored on diferrent columns within the the table.

Using Access 2002.

Help? Thanks. :)
 
Make sure the textbox is not named Nombre or ApellidoPaterno. The textbox
cannot have the name of any of the fields in the expression.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

ThePro said:
Rick B" wrote:

not sure how to do it with the expression builder, but if you are creating a
form, report, or query....
create an unboud text box and enter the following (edit for your field
names)...

=[FirstName] & " " & [LastName]

=====

Im trying to use this method and its not working. :(

Mine would look like this ...

=[Nombre] & " " & [ApellidoPaterno]

I always get an error ['#Error'] message on the field when looking at the report.

I have a table which stores all the data. A form, where users will enter
Click to expand...
the data. And a report, which is used to print what users entered via the
form. On the form I added a command button that when pressed prints the
report. Everything looks fine except the name cause Im trying to combine
both First Name [Nombre] and Last Name [ApellidoPaterno] which are stored on
diferrent columns within the the table.
 
Back
Top