Results 1 to 3 of 3

Thread: Null dates allowed

  1. Nov 16th, 2000, 08:31 AM #1
    Caro
    Caro is offline

    Thread Starter
    Addicted Member
    Join Date
    May 1999
    Location
    Littlehampton, W Sussex GB
    Posts
    203
    I have a text box linked to a data control date field which may or may not be present - If I blank it out and then update I get an error how do I create a null date in my text box?
    Reply With Quote Reply With Quote
  2. Nov 16th, 2000, 08:36 AM #2
    Bigley
    Bigley is offline
    Hyperactive Member
    Join Date
    Feb 2000
    Posts
    284
    If there is a possibility that you are going to be setting a text box value to a null field value you should include double quotes before hand as follows

    text1 = "" & recordset!myDate
    Reply With Quote Reply With Quote
  3. Nov 16th, 2000, 08:37 AM #3
    SteveFlitIII
    SteveFlitIII is offline
    Lively Member
    Join Date
    Aug 1999
    Location
    Blackpool, England
    Posts
    87
    Has the database field got AllowNulls? set to NO if it has set it to YES. This will allow you to update the field with a NULL value
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width