Classic ASP Discussion - Access and numeric fields

Print Page | Close Window

Access and numeric fields

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10752
Printed Date: 31 March 2026 at 3:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access and numeric fields

Posted By: zaboss
Subject: Access and numeric fields
Date Posted: 05 June 2004 at 1:58pm

I have run into a strange problem using access. I have a form for inserting and updateing some tables. Well, it seems that I can leave a numeric field blank. That it should have been a problem, but in this particular case blank is blank, an 0 is 0. If there is no information, the field should remain blank. How can I overcome this?
And yes, the field is set not to be required.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web

Replies:

Posted By: Semikolon
Date Posted: 06 June 2004 at 12:23pm

have you set a default value?

Posted By: zaboss
Date Posted: 06 June 2004 at 12:28pm

Sorted out. I have tryed to fill in the db with strings, and When the field is populated (with 5 for example) the string is automatically cast into a number, however if the field is empty the sting is passed and therefore an error returned. SO, I did a suplementary check, and when the string is empty I drop it.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web