Concatentation causes parameter prompt

  • Thread starter Thread starter Miaplacidus
  • Start date Start date
M

Miaplacidus

I have a report based on a query. When I try to
concatenate ie =FirstName & " " & LastName in a field on
the form the system responds with a parameter prompt but
if I just put in LastName it works OK.

What causes this?
 
Miaplacidus said:
I have a report based on a query. When I try to
concatenate ie =FirstName & " " & LastName in a field on
the form the system responds with a parameter prompt but
if I just put in LastName it works OK.

What causes this?
Click to expand...

When a parameter prompt appears it means that access cannot find a field you
specified. Are you sure the first name field is "FirstName"?

Try putting a space after the equals sign.

It is much easier in a report if you do the concatenation in the query.
There would be a column in the query like this:

FullName: [FirstName] & " " & [LastName]


Then the control on the report would set the control source as FullName.

HTH
 
Back
Top