There are some fields on our form which when filled should be saved to the database. Now, if the user doesnt enter any value for a particular field then that should be saved as NULL by default. How should this be done???
NULL value Problem
Collapse
X
-
-
Originally posted by mcluelessThere are some fields on our form which when filled should be saved to the database. Now, if the user doesnt enter any value for a particular field then that should be saved as NULL by default. How should this be done???
Rey SeanComment
-
Originally posted by lotus18The default is null (of course), unless you set your fields to "Yes" (Required). I assume you're working on access.
Rey Sean
And the user is asking for data entry from the form .
Read the questions properly before replying and no need to assume anything .
If you have any doubts just ask the user to clarify that .Comment
-
Originally posted by debasisdasWho told you that the default value is NULL ?
And the user is asking for data entry from the form .
Read the questions properly before replying and no need to assume anything .
If you have any doubts just ask the user to clarify that .
Rey SeanComment
-
Originally posted by mcluelessThere are some fields on our form which when filled should be saved to the database. Now, if the user doesnt enter any value for a particular field then that should be saved as NULL by default. How should this be done???
You could try to set the default value manually If Text1.Text="" Then Text1.Text="nul l" or just leave it blank..
Better Than YesterdayComment
-
Originally posted by werksHi there,
You could try to set the default value manually If Text1.Text="" Then Text1.Text="nul l" or just leave it blank..
Better Than Yesterday
There's also another option for that, you can set your (database) field's properties to Default Value to "NULL". It would automatically display 'NULL". but of course this depends upon what strategy are you going to used in saving your record.Comment
Comment