PDA

Click to See Complete Forum and Search --> : NULL value


Serge
Dec 10th, 1999, 12:10 AM
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 (http://www.icq.com/51055819)

MartinLiss
Dec 10th, 1999, 12:17 AM
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

matcathy
Dec 10th, 1999, 11:46 AM
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.