Results 1 to 3 of 3

Thread: NULL value

  1. #1

    Thread Starter
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    When you're assigning the value to your textbox use an empty string at the beginning:

    Text1.Text = "" & rs(Index)

    ------------------

    Serge

    Software Developer
    Serge_Dymkov@vertexinc.com
    Access8484@aol.com
    ICQ#: 51055819


  2. #2
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,175

    Post

    There are several ways around the problem. One of them is to do the following before moving the data to the control. MyValue = MyValue & "". That is just a double-quote and not a blank.

    ------------------
    Marty

  3. #3
    Junior Member
    Join Date
    Nov 1999
    Posts
    17

    Post

    Trying to retrive data from DB that initally containing nothing, NULL. Error when copying to a Mask Edit Box.
    "Invalid use of Null" with Run-time error 94

    Any idea.

    Thanks.

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