Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper Contributor

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

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