Swapping data from one field to another field

You can swap the contents of a field to another field. This operation modifies all records in the current lookup, so before performing it, create a lookup of the contact, group, or company records you want to modify.

If the size of the source field is greater than the size of the target field, some data loss may occur. Back up your database before using the Swap Field function. This function changes all data in a lookup, and can cause data loss.

To swap data from one field to another field

1. Create a lookup.

2. From the Edit menu, select Swap Field.

3. In the Swap Data dialog box, in the Swap contents of field, select a field from the list.

4. In the With contents of field, select a field  from the list, and then click OK.

5. At the confirmation message box, click Yes.