Can concatenated fields be overwritten? 1

[Ravensleach]

My client wants a field that constructs an individual's full name from their [Surname], [Title] [FirstName]

I can do that ok, but she also wants to be able to overwrite it, so that if the expression produces e.g.
"Smith, Mr Robert" she can change it to "Smith, Mr Bob"

Is this possible?

Thanks

 

[BNPMike]

You can't update a derived field. Access wouldn't know how to assign the edit to constituent fields.

If you do this on a form you can present the data in the appropriate format without concatenating the fields, with a judicious bit of left and right aligning.