How to combine two field in one field

A

Alan48

In the acees, I got two field call: Name, Othername
For example:
Name Othername
Michael Jordan
Reggie Miller

I want the display in report can show as below:
Micheal Jordan
Reggie Miller

This two field combine to one text field

I have tried change it to
[Name] && [Othername]

But i doesn't work. Then how can i do to solve this problem? Do i need to do
something in query first? Thank you very much.
 
A

Allen Browne

Try:
=[Name] & " " & [Othername]

Actually, Name is not a good name for a field. Most objects in Access have a
Name property, so you could end up with Access showing the name of the
report instead of the contents of the Name field.

You also need to make sure that this text box is not named Name or OtherName
or any other field name: Access gets confused if a control has the same name
as a field, but is bound to something else.
 
A

Alan48

Is it a create a new text field and type in this
=[Name] & " " & [Othername]
in control source?

It prompt out error. I have changed the field name to [FULLNAME], [CFULLNAME]
already. it still prompt out error. Did i do the wrong step? thanks
 
A

Alan48

Sorry,Allen Browne. It works now. thanks for your help.

Allen Browne said:
Try:
=[Name] & " " & [Othername]

Actually, Name is not a good name for a field. Most objects in Access have a
Name property, so you could end up with Access showing the name of the
report instead of the contents of the Name field.

You also need to make sure that this text box is not named Name or OtherName
or any other field name: Access gets confused if a control has the same name
as a field, but is bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Alan48 said:
In the acees, I got two field call: Name, Othername
For example:
Name Othername
Michael Jordan
Reggie Miller

I want the display in report can show as below:
Micheal Jordan
Reggie Miller

This two field combine to one text field

I have tried change it to
[Name] && [Othername]

But i doesn't work. Then how can i do to solve this problem? Do i need to
do
something in query first? Thank you very much.
Click to expand...
Click to expand...
 
D

David C. Holley

..ControlSource = [FirstFieldName] & " " & [SecondFieldName]
or in the recordSource
exprFieldName: [FirstFieldName] & " " & [SecondFieldName]
 
Top