Space betwen Name and Surname

K

kuben

Hi

I have two fields [Name] and [Surname]. What I insert this on a report
I would like the name and surname to be side-by-side without any extra
space between.

I don't know if this makes sense??

Kuben
South Africa
 
O

Ofer

Create a field in the report and in the control source you can write
=[Name] & [SurName]
 
F

fredg

Hi

I have two fields [Name] and [Surname]. What I insert this on a report
I would like the name and surname to be side-by-side without any extra
space between.

I don't know if this makes sense??

Kuben
South Africa
Click to expand...

Use an unbound control in the report.
Set it's Control Source to:
=[FirstName] & " " & [Surname]

Note 1: I assume you do want at least one space between the names.
Note 2: Name is a reserved Access/VBA/Jet word and should not be used
as a field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
O

Ofer

Thanks Larry,
I didn't forget, I got confused because Kuben asked to have no extra space
between the two fields.
After Fred replied I realized my mistake.



Larry Linson said:
Ofer said:
Create a field in the report and in the control source you can write
=[Name] & [SurName]
Click to expand...

Ofer, you forgot the space -- =[Name] & " " & [SurName]

I know you knew this and just typed too fast...
Click to expand...
 
L

Larry Linson

Ofer said:
Create a field in the report and in the control source you can write
=[Name] & [SurName]
Click to expand...

Ofer, you forgot the space -- =[Name] & " " & [SurName]

I know you knew this and just typed too fast...
 
Top