S - Specific features
Note that from 2024, the S field contains 2 values (min-max) instead of 4.
Fields created before will keep the full value up to the moment the value is being updated.
-
To open the advanced options of an S field, click on File to go to the backstage section, in Database, click Edit fields.
-
Select the right table and double click on the S field.
-
Go to step 2 of the wizard and click on the Advanced options button.
Minimum allowed value: user cannot enter a value smaller than the minimum value.Default minimum value, Default maximum valueNote: values must be in increasing order (minimum <= maximum).Maximum allowed value: user cannot enter a value higher than the maximum value.Note: default value is 0 for both (minimum and maximum value) which means no restrictions in terms of value.
4. Click OK to save the settings.