Results 1 to 2 of 2

Thread: Null values / Numeric fields / DataControl

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Location
    Suippes - FRANCE
    Posts
    3

    Post

    On a form, put :
    A DataControl
    A TextBox (or any other edit Control, bound to a numeric field of the database that the DataControl manages(The REQUIRED property of the field is well set to FALSE)
    The TextBox correctly read data from the numeric field and correctly write data looking like numeric values ... OK BUT ...
    When setting the TextBox to blank (= erasing previously recorded data), and trying to update the database with the new "NULL" value : CRASH (message : "data conversion error")
    Nevertheless, if you perform this update programmatically, it works :
    MyRecordset.edit
    MyRecordset.MyField = Null MyRecordset.update

    I think it's because of the dataControl itself ... How to make it able to accept Null strings as Null values for numeric fields ???

    Thank you for your help.


  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    Is that a DAO data control or ADO data control?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width