check if all records in a field are null using vba

[amahdian]

This might be a very simple question but I was wondering how you can
check whether all the records in a specific field of a table have null
in them. The following doesn't work:

If myTable.Fields("myField").Value Is Null Then
.........
End If

Thanks,

[Mary]

If IsNull([MyField]) Then ...

On Jan 24, 11:14 am, [e-mail] wrote:

This might be a very simple question but I was wondering how you can
check whether all the records in a specific field of a table have null
in them. The following doesn't work:

If myTable.Fields("myField").Value Is Null Then
.........
End If

Thanks,

[Marshall Barton]

am******@gmail.com wrote:

>This might be a very simple question but I was wondering how you can
check whether all the records in a specific field of a table have null
in them. The following doesn't work:

If myTable.Fields("myField").Value Is Null Then

If DCount("*", "myTable", "myField Is Not Null") 0 Then

--
Marsh

[Mary]

I'm sorry - I read the question too quickly.

On Jan 24, 11:56 am, Marshall Barton <[e-mail]:

[e-mail] wrote:

This might be a very simple question but I was wondering how you can
check whether all the records in a specific field of a table have null
in them. The following doesn't work:

If myTable.Fields("myField").Value Is Null ThenIf DCount("*", "myTable", "myField Is Not Null") 0 Then

--
Marsh