Merci Ecric,
For the function that can do this well How about this!
Function EmptyTxt( Txt as String) as integer
if Txt & "" = ""
return 0
endif
return 1
>>I have a form with my data object bound to a access MDB database ans some fields do not have any entre so the value is null.
>>
>>How can I know if the field is empty. I need to know if it empty or null. Same thing for me.
>>
>>I know we can use a function but I cannot find it.
>
>By "bound", do you mean that you had set the DataSource and the DataField properties? If so, I think that the only way to correct it is to insure that your database doesn't contains Null.
>
>If you populate yourself controls on the forms, there is at least 2 ways:
>1. Use the IsNull() function.
> example: text1.text = iif(isnull(rs!field1), "", rs!field1)
>2. If your fields are text fields, concatenate an empty string to it.
> example: text1.text = rs!field1 & ""
>
>I don't know any functions that returns a value telling if the programmer is null. Maybe in the next version! Send your request to the VB wish list!!!