I am a bit of a newbie to MS Access and I am wondering how to set a field in a table to have a default value, even when the record has been updated.
I am using an ASP upload script which enables the user to insert multiple files from one page. The problem being when one of the file fields is left blank and a blank value is entered into the db and the default value of 'empty' is removed. (I am needing this default value for a different script)

Basically, what I am trying to do is specify in Access that if the field is blank to assign a value of 'empty' to it.

Any ideas anyone? Any help is appreciated.