Space betwen Name and Surname

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6168-space-betwen-name-and-surname.html


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Create a field in the report and in the control source you can write
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168
=[Name] & [SurName]
--
Good luck



"kuben@angelus.co.za" wrote:

> 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
>
>

On 29 Oct 2005 0735 -0700, kuben@angelus.co.za wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168

> Hi
>
> I have two fields [Name] and [Surname]. What I insert this on a report
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168
> 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

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'
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

"Ofer" wrote in message
news:1A935A62-877A-4859-8B1B-F277C880C1A3@microsoft.com...
> Create a field in the report and in the control source you can write
> =[Name] & [SurName]

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

I know you knew this and just typed too fast...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168

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" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6168
>
> "Ofer" wrote in message
> news:1A935A62-877A-4859-8B1B-F277C880C1A3@microsoft.com...
> > Create a field in the report and in the control source you can write
> > =[Name] & [SurName]
>
> Ofer, you forgot the space -- =[Name] & " " & [SurName]
>
> I know you knew this and just typed too fast...
>
>
>
>
>