Validation and Entry of a value from a Valid Entries List may also be controlled using the "*" (asterisk character) to require validation of only the first part of an Entry (ignoring the remaining characters).
In the Value Column on the Edit Valid Entries List screen, enter the part of the Value that requires validation, followed by the asterisk character. Any Entry matching the characters before the "*", and followed by additional characters is considered a Valid Entry.
For example, if the Value is "Smith*", Valid Entries include anything beginning with "Smith" such as:
Smith
Smithfield
Smith Holding Co.
Smith & Johnson
Invalid Entry examples include:
McSmith
S. Smith
Smit
Smitz
Smitty's
Note: If any characters are placed after the asterisk in the Value, the asterisk is treated as a character in the Value and requires a match for the entire Entry. For example, the Value Smith*field allows only Smith*field as a Valid Entry.
See:
Database List Editor Contents