Multiple Fields in one text box

[Hollis]

Hello everyone,

I'm making a list of people attending a program and I have their last and family name in diffrent fields (FirstName, FamilyName).

Is there any way to have these two fields in the same text box so that the list looks like this:

Aaron Hills
Bob Brown
Gorden Hollis

rather than

Aaron Hills
Bob Brown
Gorden Hollis

Thanks.

 

[pbaldy]

Try a textbox with a control source of:

=FirstName & " " & FamilyName

 

[Hollis]

Thanks for that, it looks like it should work but it's coming up with an #Error where that text box is, I'm using Access 2000, would that change anything?

 

[Hollis]

I got this working:

="FirstName" & " " & [FamilyName]

while this produces a #Error

=[FirstName] & " " & [FamilyName]

 

[pbaldy]

Should work in any version. Make sure you don't have a control with either of those names, which can confuse Access. Given your follow-up, my guess is that there's a control named FirstName.

 

[Hollis]

You are spot on there pbaldy, I did have a contol named FirstName, after I changed that it worked a treat.

Thanks greatly for your help