Hard to help without seeing what you tried and knowing the data type of the field.
Paul (wino moderator) MS Access MVP 2007-2019 www.BaldyWeb.com
Forum Rules