Fix company field truncation and formatting after address validation
After address validation, the company field is truncated to 50 characters, and formatting may be updated to mixed case.
The following instructions will restore the company field to its original state, which is useful for truncation and formatting.
- Before address validation, pull down the Edit menu to Fields.
- Increase the LEN column of the company field to 150 characters.
- If you do not have a field named ocompany, create that field, and change the LEN to 150 characters.
- Click OK and click Yes.
- In the Address Validation feature, make sure the Preserve Original Company box is checked.
- Run address validation.
- After validation, pull down the Edit menu to Command.
- Create a new command, naming it Fix company field truncation and formatting
- In the Command Statement Syntax area, paste the following command:
| Replace all company with ocompany |
- Click Run, then close the Command window.
The company field is restored to its original state.
