I'm looking for a line (or more) of VBA that would tell me how to set the "required" property of a field to "No" instead of "Yes"
Just so you have the context, I'm helping someone write a module that imports data into an Access database. Of course, sometimes a field or two is blank. When I look at the properties for the field, the "required" property says yes. If there is a way to turn it off for all fields (except for the key of course), I'd love to know how it's done.
Thanks in advance folks.