Problems with readin a field in my Access database

[ingrid]

Hello VB programmers,

Reading out the next field in my database

AcadInfoDYN(“TEST”)

If a field is not filled in it will give the next error:

Invalid use off null

Before reading, how can I prevent this error?

Nice greetings,

Ingrid.

[smalig]

You can use the IsNull() function to see if it's null or use construction !field & "".

------------------
smalig
smalig@hotmail.com
smalig.tripod.com (http://smalig.tripod.com)

[JorgeLedo]

When reading try this:

If Not IsNull(AcadInfoDYN(“TEST”)) Then
'put code here
else
var = ""
End If

------------------
Jorge Ledo
j_ledo@hotmail.com
Portugal

[Serge]

The easiest way is to do this:


Text1.Text = "" & rs("MyField")


Regards,

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

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com