Do it in a query like so:
SELECT (FirstName + " ") & Surname AS FullName
FROM YourTable;
In query design view you'd do it by entering the following in the 'field'
row of a blank column in query design view:
FullName: ([FirstName + " ") & [Surname]
By using the + operator to add the space between the names the space will be
suppressed if by any chance someone was recorded only by their surname. This
is because Null + " " = Null (the Null propagates), whereas Null & " " = " "
so would insert an unwanted leading space.
Do not under any circumstances store the full name as a separate column in
the table, always return it in a query as described above, or in an unbound
control on a form or report using a similar expression as the ControlSource
property. Its much easier to build values from several columns than to parse
a value in a single column into separate values.
BTW if you don't already have one, add a numeric ID column of unique values
(e.g. an autonumber) as the table's primary key. Names are not suitable for
keys as they can be duplicated.
Ken Sheridan
Stafford, England