I would not put the format string in the table. Put it in the control that displays the field instead. AutoNumber PrimaryKeys are not really for human consumption anyway. Normally I do not reference another forum but it was such a long and well written post that I thought I should break my rule this time. It will still not eliminate your problem if you are going to ask for user input on a search.