I have a text field in a table that must be entered in a particular format: “# - # - #” where # represents a number. I’ve tried to use “format field” in table design view, but while it displays the requested format, I can still enter incorrect data.
How do I enforce that format on entry? I can find plenty of advice on formatting dates and numbers, but nothing for text. Thanks in advance.