Forum Discussion

Kwoolridge's avatar
Kwoolridge
Copper Contributor
Oct 14, 2020

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")

Resources