Access2000 Form

[§Chrissi§]

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a textbox.
I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But when I
run it, it does not display the fullname. What is wrong?

Thank you.

 

[Graham R Seach]

Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " & [Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[§Chrissi§]

It does not work. Did you make it work?

Thanks.

Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But
when I run it, it does not display the fullname. What is wrong?

Thank you.

 

[Graham R Seach]

OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or are they
controls on the current form, or are they controls on a different form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

It does not work. Did you make it work?

Thanks.

Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But
when I run it, it does not display the fullname. What is wrong?

Thank you.

 

[§Chrissi§]

LastName and FirstName fields are in the table Employees in MS Northwind
database.

If you have MS Access, you should have the database and you could try it.

Thanks

OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or are
they controls on the current form, or are they controls on a different
form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

It does not work. Did you make it work?

Thanks.

Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But
when I run it, it does not display the fullname. What is wrong?

Thank you.

 

[Brendan Reynolds]

Is the form bound to the Employees table (or to a SQL statement or saved
query based on the Employees table)? What is in the Record Source property
of the form?

--
Brendan Reynolds

LastName and FirstName fields are in the table Employees in MS Northwind
database.

If you have MS Access, you should have the database and you could try it.

Thanks

OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or are
they controls on the current form, or are they controls on a different
form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

It does not work. Did you make it work?

Thanks.
Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But
when I run it, it does not display the fullname. What is wrong?

Thank you.

 

[§Chrissi§]

Record Source property
of the form is Employees

Is the form bound to the Employees table (or to a SQL statement or saved
query based on the Employees table)? What is in the Record Source property
of the form?

--
Brendan Reynolds

LastName and FirstName fields are in the table Employees in MS Northwind
database.

If you have MS Access, you should have the database and you could try it.

Thanks

OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or are
they controls on the current form, or are they controls on a different
form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia


It does not work. Did you make it work?

Thanks.
Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it. But
when I run it, it does not display the fullname. What is wrong?

Thank you.

 

[Brendan Reynolds]

In Access 2003, using a new text box added to the existing Employees form in
Northwind, either of these work for me ...

=[LastName] & ", " & [FirstName]

.... or ...

= [Employees].[LastName] & ", " & [Employees].[FirstName]

Note the "." in place of the "!" in your original example.

A lot of the time in Access, you can use "." and "!" interchangeably, but
this seems to be one of the exceptions.

--
Brendan Reynolds

Record Source property
of the form is Employees

Is the form bound to the Employees table (or to a SQL statement or saved
query based on the Employees table)? What is in the Record Source
property of the form?

--
Brendan Reynolds

LastName and FirstName fields are in the table Employees in MS
Northwind database.

If you have MS Access, you should have the database and you could try
it.

Thanks
OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or are
they controls on the current form, or are they controls on a different
form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia


It does not work. Did you make it work?

Thanks.
Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it.
But when I run it, it does not display the fullname. What is wrong?

Thank you.

 

[§Chrissi§]

It does not work in Access2000. I'll try Access2003.

Thanks.

In Access 2003, using a new text box added to the existing Employees form
in Northwind, either of these work for me ...

=[LastName] & ", " & [FirstName]

... or ...

= [Employees].[LastName] & ", " & [Employees].[FirstName]

Note the "." in place of the "!" in your original example.

A lot of the time in Access, you can use "." and "!" interchangeably, but
this seems to be one of the exceptions.

--
Brendan Reynolds

Record Source property
of the form is Employees

Is the form bound to the Employees table (or to a SQL statement or saved
query based on the Employees table)? What is in the Record Source
property of the form?

--
Brendan Reynolds

LastName and FirstName fields are in the table Employees in MS
Northwind database.

If you have MS Access, you should have the database and you could try
it.

Thanks
OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or
are they controls on the current form, or are they controls on a
different form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia


It does not work. Did you make it work?

Thanks.
Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it.
But when I run it, it does not display the fullname. What is
wrong?

Thank you.

 

[Graham R Seach]

Naturally I have Access, but I don't bother installing NorthWind - it just
takes up space.

If your form is based on the Customers table and contains the two fields
[LastName] and [Firstname], then the following will work:
=[LastName] & ", " & [FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

It does not work in Access2000. I'll try Access2003.

Thanks.

In Access 2003, using a new text box added to the existing Employees form
in Northwind, either of these work for me ...

=[LastName] & ", " & [FirstName]

... or ...

= [Employees].[LastName] & ", " & [Employees].[FirstName]

Note the "." in place of the "!" in your original example.

A lot of the time in Access, you can use "." and "!" interchangeably, but
this seems to be one of the exceptions.

--
Brendan Reynolds

Record Source property
of the form is Employees


Is the form bound to the Employees table (or to a SQL statement or
saved query based on the Employees table)? What is in the Record Source
property of the form?

--
Brendan Reynolds

LastName and FirstName fields are in the table Employees in MS
Northwind database.

If you have MS Access, you should have the database and you could try
it.

Thanks
OK, if it's not working for you, then there's something else wrong.

Are LastName and FirstName fields in the underlying table/query, or
are they controls on the current form, or are they controls on a
different form?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia


It does not work. Did you make it work?

Thanks.
Chris,

Try this:
=[Forms]![Employees]![LastName] & ", " &
[Forms]![Employees]![FirstName]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Hi All,

I used NWIND.mdb to try to build forms. I opened a form and put a
textbox. I put
=[Employees]![LastName] & ", " & [Employees]![FirstName] for it.
But when I run it, it does not display the fullname. What is
wrong?

Thank you.