Validation Rule

[lewy the fly via AccessMonster.com]

I have a table with a cell formated to Date/Time and I wish to set the
validation rule to allow either a date or the letters TBA to be inserted. Is
this possible and if so how.

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200610/1

[pietlinden@hotmail.com]

Re: Validation Rule


lewy the fly via AccessMonster.c om wrote:

I have a table with a cell formated to Date/Time and I wish to set the
validation rule to allow either a date or the letters TBA to be inserted. Is
this possible and if so how.
>
--

Don't think you can. You could leave the unknown values Null, and then
just format the Null values in your form/report using an IIF statement
or conditional formatting.