combining text values from multiple fields

  • Thread starter Thread starter vwillia2
  • Start date Start date
V

vwillia2

I am trying to combine text in the "Control Soure" text
box to combine my [FirstName] and [LastName] fields.

When I used the expression below, I received an error
stating Microsoft Access can't find the field refered to
in your expression. Am I doing something wrong? When I
entered the expression in my training class, I had no
problem. Could there be a difference between Access 97
and Access 2002 (which I'm using now) that could cause the
error?

Here's the expression I used:
[First Name]&' '&[Last Name]

My field names do have a space in between the names so
it's not that. I also tried using quotation marks (")
instead; that was't it. I tried adding an equal sign (=);
that wasn't it? What else could it be?
 
vwillia2 said:
I am trying to combine text in the "Control Soure" text
box to combine my [FirstName] and [LastName] fields.

When I used the expression below, I received an error
stating Microsoft Access can't find the field refered to
in your expression. Am I doing something wrong? When I
entered the expression in my training class, I had no
problem. Could there be a difference between Access 97
and Access 2002 (which I'm using now) that could cause the
error?

Here's the expression I used:
[First Name]&' '&[Last Name]

My field names do have a space in between the names so
it's not that. I also tried using quotation marks (")
instead; that was't it. I tried adding an equal sign (=);
that wasn't it? What else could it be?

As long as the field names are valid fields in the report's
record source table/query and the text box is named
something other than the name of a field,

=[First Name] & " " & [Last Name]
 
Back
Top