Textbox for data values in MS Access
Posted on 2016-09-09
I have an Access form with a textbox for the user to enter a date value. Its format is Short Date.
Under normal circumstances the user will enter a date value. If (s)he enters anything else or enters the date in an improper format, an error message will be sent to the screen.
I'd like to keep the above behavior but for one exception. I'm wondering if there is a way for the user to be able to select "NA" (for not applicable) or to be able to type it in. I don't mind if I have to change the textbox to a combobox or some other object.
In other words, I want to force the user to enter a value into the box and not be able to leave it blank. But the only values that can entered are either a date in proper format or "NA".
I don't even care if I have to layer 2 controls on top of each other to accomplish what I'm asking. Just from the user's perspective, I'd like it to be seamless. Either a date gets entered into the box or an "NA" gets selected (or manually entered).