Problem with Empty Number Field
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5533
Printed Date: 30 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problem with Empty Number Field
Posted By: rcalvert
Subject: Problem with Empty Number Field
Date Posted: 04 September 2003 at 4:37pm
|
I am in the middle of building an asp ms access application, one of the form pages is an update record form which updates several fields with the default values from the database displayed. For my reports to work i need to have a value in all of the fields. I have set the default value in access to 0 but if you delete one of the values in my update form and then submit the record is left with an empty value in the field. Any suggestions much appreciated. many thanks in advance ------------- 
|
Replies:
Posted By: pmormr
Date Posted: 06 September 2003 at 6:08pm
|
in your update page you can say something like this: If request.querystring("idvalue") = "" then ------------- Paul A Morgan http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/ |