Forum Discussion
How to get an unfilled form field return N/A in the table.
I'm still pretty new to access, so this might be a dumb question. I'm creating a database to track product changes and such for work. So, I have a couple of tables and a form that should fill out tho...
Why not setup a combo box with that as an option?
Our you could use the before update event to convert null values to n/a by looking over the form controls.
Or, forget about saving a whole bunch of N/A value, leave it blank and instead use IsNull() in your queries and forms as required.
IsNull([YourFieldName], "N/A")
Our you could use the before update event to convert null values to n/a by looking over the form controls.
Or, forget about saving a whole bunch of N/A value, leave it blank and instead use IsNull() in your queries and forms as required.
IsNull([YourFieldName], "N/A")