Combine name on a form

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi,

I have a form which is based on a table, I want to
combine the Forname and Surname fields into one so
|john|Smith| would be |Smith,John| on the form, but i
can't get it to work. Any Ideas?

Cheers

daniel
 
On the control source of the text field, type:
=[ForName] & ", " & [Surname]

Hope this helps.
 
Back
Top