Results 1 to 2 of 2
Thread: Default Values...
Feb 20, 2002, 00:47 #1
- Join Date
- Feb 2002
- 0 Post(s)
- 0 Thread(s)
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.