"Optional" input masks?

[fastrunr]

Hello,

I have the following input mask applied for a date (non-required field):

99/99/0000;0;_

and a default value of "NDF" ("No Data Found").

The field is automatically filled in with "NDF" if the user does not enter a date. However, is there any way to enable the user to type or paste in "NDF" himself if a date value is not available? Perhaps by applying two alternative input masks (if possible)?

Any help appreciated!

Thanks,
Liz

 

[dhookom]

If the field is a date field, then there is no way to store NDF in the field. You can set the Format property of a control on a form or report to:
Format: mm/dd/yyyy;;;"NDA"

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fastrunr]

Oops. I said date field, didn't I? I should've said that it's a date stored in a text field. Totally different. So, with that in mind, is there any way to enable the user to type in "NDF" (the default value) when there is no data available fitting the input mask format (99/99/0000;0;_)?

Thanks again,
Liz