Forum Discussion
Kwoolridge
Oct 14, 2020Copper Contributor
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 those tables. If a field on the form isn't applicable for the particular product I'm entering into my database, is there a way to have "N/A" entered in that field in the table?
Thanks,
Kendra Woolridge
- 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")