Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving a null text field which bound to a date field
Message
From
04/11/1997 01:59:49
Chew Houng Low
Mbf Information Services Sdn. Bhd.
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
Saving a null text field which bound to a date field
Miscellaneous
Thread ID:
00058103
Message ID:
00058103
Views:
88
I have a problem when I try to save a null date into database.
This is the scenario:

Create a Access database with a table in it.
The table has a date field(Required property set to no).
Add a few date record into it: eg 1/1/90, 1/2/90, 1/3/90

Create a VB form and put a data control onto the form
Create a text field that bound to the date field in the data control.
Create a command button that contain the following command:
data1.updaterecord

Run the project and move the current record to 1/2/90 and
delete the contains of the field and press the command button.

An error: Data conversion error occured.

Can anyone help me to solve the above problem?
Low Chew Houng
MBf Information Services Sdn. Bhd.
Subsidiary Of MBf Group Of Companies
chewhoung@yahoo.com
Next
Reply
Map
View

Click here to load this message in the networking platform