Advanced Recordset Field Preferences

On the Recordset tab in the Preferences Setup dialog box, click the Advanced button to open the Advanced Recordset Field Preferences dialog box.

If you are not working with a character-mode host, the controls in the Advanced Recordset Field Preferences dialog box are unavailable.

Click any of the following options for more information:

Fetch: Remove blanks
Select the Leading, Trailing, or All check boxes to remove spaces from fetched data.
Update: Erase to end of field
Select this check box to concatenate as many spaces as necessary to make the length of the input match the length of the field.
Character mode data entry