Can you offer any more insight as to what you are trying to accomplish?
Typically, it is not good practice to store the same data redundantly, or to
store calculated values. If you need to combine the values for display
purposes, or as a calculation, you can use a query or an unbound control
on a form, etc.
Set the control source of the control on your form to [Field1] & " " &
[Field2]. Obviously, you need to use the actual names of the fields
that are in the forms record source.
Lynn Trapp www.ltcomputerdesigns.com