Date to blank.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Date to blank.

  1. #1
    Murray Foxcroft Guest

    Date to blank.

    I'm trying to blank out a text field that holds a date value - i.e. set it
    to nothing.
    The access database wont accept "" as a 'null' value.




  2. #2
    mrfelis Guest

    Re: Date to blank.

    Try:
    oRS!dteBlank = Null

    --
    ~~~
    C'Ya,
    mrfelis
    mrfelis@yahoo.NOSPAM.com
    just remove the spam
    Murray Foxcroft <foxman@xsinet.co.za> wrote in message
    news:39f55a6b@news.devx.com...
    > I'm trying to blank out a text field that holds a date value - i.e. set it
    > to nothing.
    > The access database wont accept "" as a 'null' value.
    >
    >
    >




  3. #3
    Murray Foxcroft Guest

    Re: Date to blank.

    Its embedded in a class and setting the record value as shown below, does
    not work.
    But thanks - it was worth a shot 8-)

    "mrfelis" <mrfelis@yahoo.NOSPAM.com> wrote in message
    news:39f57a86$1@news.devx.com...
    > Try:
    > oRS!dteBlank = Null
    >
    > --
    > ~~~
    > C'Ya,
    > mrfelis
    > mrfelis@yahoo.NOSPAM.com
    > just remove the spam
    > Murray Foxcroft <foxman@xsinet.co.za> wrote in message
    > news:39f55a6b@news.devx.com...
    > > I'm trying to blank out a text field that holds a date value - i.e. set

    it
    > > to nothing.
    > > The access database wont accept "" as a 'null' value.
    > >
    > >
    > >

    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center