Short Date Field and "N/A"

[sjl]

I have a short date field that I want to change to also allow “N/A”.

The current input mask is: 99/99/0000;0;_
The current validation rule is: Between #1/1/2006# And #1/1/2015#

Is it possible to add a “N/A” to the field???
(I've not been able to get it to work)

 

[boblarson]

You'll have to use an unbound text box for this because a bound date field cannot accept text.

 

[sjl]

Thanks for heading me in the right direction, Bob.

I'll look into unbound text boxes for my Form. However, would I also need to add "Or "N/A" to the Validation Text of the short date field in the Table? what about additions to the input mask? thanks much.

 

[boblarson]

Thanks for heading me in the right direction, Bob.

I'll look into unbound text boxes for my Form. However, would I also need to add "Or "N/A" to the Validation Text of the short date field in the Table? what about additions to the input mask? thanks much.

You wouldn't validate at table level. Validate on the form. And, you can have a bound text box (hidden) that will store your date and your displayed text box can display something based on that text box.

 

[sjl]

How interesting. I'll give it a go.
Gracias!
S.

 

[RoyVidar]

Do you have to store that text? Or is it just for display purposes?

If it's only for display purposes, you could enter something like this into the format property of the control where you need it displayed or into the format property of the table field

mm\/dd\/yyyy;mm\/dd\/yyyy;mm\/dd\/yyyy;"N/A"

Then every Null entry (where no date is entered), will display as N/A. No extra field, control or other workaround should be needed.

You'd need to alter the validation rule to

Between #1/1/2006# And #1/1/2015# Or Is Null