I need to be able to enter a date and a literal in the same field such "11/15/01" and "Indefinite". In AREV when you paint a window you can create a prompt field with multible validation patterns such as "(D)" and "Indefinite" and an "Output Format" of "D4/" which works great. In OI, when I create a form the same way and enter "Indefinite" it does not give me an error though it clears the field when I leave the field.

So, how can I solve this problem?

Rick

Rick,

I think I understand what you're asking.

What I would do is us a DBTable with the date in one column and Indefinate in the second column. If you want to have only one entry, limit the entries in the More Properties window to 1.

There are more things that you can do, but I think this will get you started.

If I misunderstood you I'm sorry and hope someone else can help you.

Richard Richter

Rick,

When you set the Conversion and Validation of a field in an OI form to some date format, there is of course some programming invoked that does the necessary validation and conversion on the user's data. What you can do is to write your own version of that programming - a so-called UDC.

Come to think of it - Mike Ruane helped me once with a related case and his programming is almost exactly what you need. You lucky guy! See !

(Btw - You mentioned Arev. This conversion/validation stuff is slightly different in OI and Arev.)

- Oystein -

View this thread on the Works forum...