Data type conversion error when saving numeric data types
I believe that was one of the items corrected in Visual Studio SP3 about
null variables in databases. If you don't have SP3 installed, give that a
shot. I am assuming you have VB6 Professional or above.
--
Craig Luecke
Technical Information Specialist / Webmaster
Fairfax County International Urban Search and Rescue
WEB: http://www.vatf1.org
Quote:
> I have a textbox which is bound to an Access database field (numeric data
> type).
> If I type a digit into the box, then the record can be saved ok. If I
> remove the digit again and try to save the record, then I get a data type
> conversion error.
> Does anyone know a way around this, so that if a user blanks the box, then
> the record can be saved, and the box remains blank?
> I know I can do this in an Access form, but can not seem to just blank the
> box in a VB form.
> Even 'text1 = val(text1)' just puts a zero in the box, but I do not want a
> setting of zero if the user wants no setting to be printed.
> Any help would be very much appreciated, as this has been bugging be for a
> while now.
> Thanks
> Ed
