regarding ado database

hello guys..

in my application i m using ado database and to let users modify old data i m opening the data to the text box using following statement

Form1.txtnofiles.Text = adorecordset_recevoi.Fields("nofiles")

but on execution it gives error 'non authorised use of Null'...pls tell me what is this error and how to get rid of it...

thanx...

Try

Form1.txtnofiles.Text = IIF(IsNull(adorecordset_recevoi.Fields("nofiles")), "", adorecordset_recevoi.Fields("nofiles"))

thanx buddy for the rply but its not working and giving some error....

hello guys..

in my application i m using ado database and to let users modify old data i m opening the data to the text box using following statement

Form1.txtnofiles.Text = adorecordset_recevoi.Fields("nofiles")

but on execution it gives error 'non authorised use of Null'...pls tell me what is this error and how to get rid of it...

thanx...

Try:

Form1.txtnofiles.Text = "" & adorecordset_recevoi.Fields("nofiles")

Hey msmeth! Try this simple function:


Public Function NullToEmpty(vValue As Variant) As Variant
If Not IsNull(vValue) Then
NullToEmpty = vbNullString
Else
NullToEmpty = vValue
End If
End Function

...
Form1.txtnofiles.Text = NullToEmpty(adorecordset_recevoi.Fields("nofiles"))
...


good luck!
bye

Hi Verito! Thanks, but it's not for me....I hope deepaka finds it useful though ;)

Hey msmeth! Try this simple function:


Public Function NullToEmpty(vValue As Variant) As Variant
If Not IsNull(vValue) Then
NullToEmpty = vbNullString
Else
NullToEmpty = vValue
End If
End Function

...
Form1.txtnofiles.Text = NullToEmpty(adorecordset_recevoi.Fields("nofiles"))
...


good luck!
bye

:)
deepakaa i made a mistake, replace:

If Not IsNull(vValue) Then


for


If IsNull(vValue) Then


:)
good luck!