How to get an unfilled form field return N/A in the table.

[Kwoolridge]

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

[#2]

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