Concatenating two fields in a form to create a third field

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

Hi,

I have a table with the following fields:
-ID
-Fname (first name)
-Lname (last name)
-Name (first and last name)
In the form, I have the following expression for Name:
=[Table1]![FName] & " " & [Table1]![LName]

It is not working, and I'm not sure what I'm doing wrong.
I get the following text in the textbox
for "Name": "#Name?".

Any help will be appreciated. Thanks!

-Amit
 
Amit said:
Hi,

I have a table with the following fields:
-ID
-Fname (first name)
-Lname (last name)
-Name (first and last name)
In the form, I have the following expression for Name:
=[Table1]![FName] & " " & [Table1]![LName]

It is not working, and I'm not sure what I'm doing wrong.
I get the following text in the textbox
for "Name": "#Name?".
Click to expand...

There is no need for this third field.
You can put =Me![FName] & " " & Me![LName] in an unbound text box on your
form

Most of the time it is best to place FullName:[FName] & " " & [LName]
in a query, then use FullName in all reports and forms.

If you don't do this and miss a form or somebody modifies a table entry then
Sue Smith who changed sex and got married will still show as Bob Jones in
some places and not others.
 
Hi Mike.

I tried what you suggested, and am still getting the same
error - #Name? .

I even tried this in a new form. Is there anything else I
could be doing wrong??

-Amit
-----Original Message-----

Amit said:
Hi,

I have a table with the following fields:
-ID
-Fname (first name)
-Lname (last name)
-Name (first and last name)
In the form, I have the following expression for Name:
=[Table1]![FName] & " " & [Table1]![LName]

It is not working, and I'm not sure what I'm doing wrong.
I get the following text in the textbox
for "Name": "#Name?".
Click to expand...

There is no need for this third field.
You can put =Me![FName] & " " & Me![LName] in an unbound text box on your
form

Most of the time it is best to place FullName:[FName] & " " & [LName]
in a query, then use FullName in all reports and forms.

If you don't do this and miss a form or somebody modifies a table entry then
Sue Smith who changed sex and got married will still show as Bob Jones in
some places and not others.


.
Click to expand...
 
Hi Mike:

I finally got it. When I created a form and had an unbound
textbox with {=Me![FName] & " " & Me![LName]} in Control
Source, I still got the #Name? error.

But, when I create a query with another field which
concatenates FName and LName, and then base the form on
this query, it works fine!!

Maybe there's no way to accomplish this without a query
inbetween the table and form...??

Thanks again for your suggestions.

-Amit
-----Original Message-----

Amit said:
Hi,

I have a table with the following fields:
-ID
-Fname (first name)
-Lname (last name)
-Name (first and last name)
In the form, I have the following expression for Name:
=[Table1]![FName] & " " & [Table1]![LName]

It is not working, and I'm not sure what I'm doing wrong.
I get the following text in the textbox
for "Name": "#Name?".
Click to expand...

There is no need for this third field.
You can put =Me![FName] & " " & Me![LName] in an unbound text box on your
form

Most of the time it is best to place FullName:[FName] & " " & [LName]
in a query, then use FullName in all reports and forms.

If you don't do this and miss a form or somebody modifies a table entry then
Sue Smith who changed sex and got married will still show as Bob Jones in
some places and not others.


.
Click to expand...
 
Amit said:
Hi Mike:

I finally got it. When I created a form and had an unbound
textbox with {=Me![FName] & " " & Me![LName]} in Control
Source, I still got the #Name? error.

But, when I create a query with another field which
concatenates FName and LName, and then base the form on
this query, it works fine!!

Maybe there's no way to accomplish this without a query
inbetween the table and form...??
Click to expand...

The query is the better way.
 
-----Original Message-----
If you did this on a form the most likely thing (when I do it) is that the
name of the textbox is also the name of one of the fields.
Click to expand...

I actually did check for this before reading your post,
and the name of the unbound textbox (fullname) in the form
is totally different from the names of the other fields
(FName and LName). So, I'm not sure why it didn't work....

But, as you can read from my earlier post, it did work
when I used a query inbetween the table and form.

Thanks again for your help, Mike.

-AV
Amit said:
Hi Mike.

I tried what you suggested, and am still getting the same
error - #Name? .

I even tried this in a new form. Is there anything else I
could be doing wrong??

-Amit
-----Original Message-----

Hi,

I have a table with the following fields:
-ID
-Fname (first name)
-Lname (last name)
-Name (first and last name)
In the form, I have the following expression for Name:
=[Table1]![FName] & " " & [Table1]![LName]

It is not working, and I'm not sure what I'm doing wrong.
I get the following text in the textbox
for "Name": "#Name?".


There is no need for this third field.
You can put =Me![FName] & " " & Me![LName] in an
Click to expand...
unbound
text box on your
form

Most of the time it is best to place FullName:[FName] & " " & [LName]
in a query, then use FullName in all reports and forms.

If you don't do this and miss a form or somebody
Click to expand...
modifies
a table entry then
Sue Smith who changed sex and got married will still
Click to expand...
show
as Bob Jones in
some places and not others.


.
Click to expand...
Click to expand...


.
Click to expand...
 
The unbound text box of:

=([Fname] & " " & [LName])

should work.

You need a set of brackts around the whole expression.


Amit said:
Hi Mike:

I finally got it. When I created a form and had an unbound
textbox with {=Me![FName] & " " & Me![LName]} in Control
Source, I still got the #Name? error.

But, when I create a query with another field which
concatenates FName and LName, and then base the form on
this query, it works fine!!

Maybe there's no way to accomplish this without a query
inbetween the table and form...??

Thanks again for your suggestions.

-Amit
-----Original Message-----

Amit said:
Hi,

I have a table with the following fields:
-ID
-Fname (first name)
-Lname (last name)
-Name (first and last name)
In the form, I have the following expression for Name:
=[Table1]![FName] & " " & [Table1]![LName]

It is not working, and I'm not sure what I'm doing wrong.
I get the following text in the textbox
for "Name": "#Name?".
Click to expand...

There is no need for this third field.
You can put =Me![FName] & " " & Me![LName] in an unbound text box on your
form

Most of the time it is best to place FullName:[FName] & " " & [LName]
in a query, then use FullName in all reports and forms.

If you don't do this and miss a form or somebody modifies a table entry then
Sue Smith who changed sex and got married will still show as Bob Jones in
some places and not others.


.
Click to expand...
Click to expand...
 
Back
Top