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

%3CLINGO-SUB%20id%3D%22lingo-sub-1781015%22%20slang%3D%22en-US%22%3EHow%20to%20get%20an%20unfilled%20form%20field%20return%20N%2FA%20in%20the%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1781015%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20still%20pretty%20new%20to%20access%2C%20so%20this%20might%20be%20a%20dumb%20question.%20I'm%20creating%20a%20database%20to%20track%20product%20changes%20and%20such%20for%20work.%20So%2C%20I%20have%20a%20couple%20of%20tables%20and%20a%20form%20that%20should%20fill%20out%20those%20tables.%20If%20a%20field%20on%20the%20form%20isn't%20applicable%20for%20the%20particular%20product%20I'm%20entering%20into%20my%20database%2C%20is%20there%20a%20way%20to%20have%20%22N%2FA%22%20entered%20in%20that%20field%20in%20the%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKendra%20Woolridge%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1781015%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1785973%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20an%20unfilled%20form%20field%20return%20N%2FA%20in%20the%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1785973%22%20slang%3D%22en-US%22%3EWhy%20not%20setup%20a%20combo%20box%20with%20that%20as%20an%20option%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOur%20you%20could%20use%20the%20before%20update%20event%20to%20convert%20null%20values%20to%20n%2Fa%20by%20looking%20over%20the%20form%20controls.%3CBR%20%2F%3E%3CBR%20%2F%3EOr%2C%20forget%20about%20saving%20a%20whole%20bunch%20of%20N%2FA%20value%2C%20leave%20it%20blank%20and%20instead%20use%20IsNull()%20in%20your%20queries%20and%20forms%20as%20required.%3CBR%20%2F%3E%3CBR%20%2F%3EIsNull(%5BYourFieldName%5D%2C%20%22N%2FA%22)%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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")