how to make a field null in access

[Resmy Ravi]

how to make a field null in access

[Stewart Ross]

You don't give us enough to go on in what you have posted - please note that we cannot do much to advise you if you take so little care over what you ask.

Short answer to your very short question is to set the field (or control on a form if that is what you really mean) to the value defined by the reserved keyword Null. Nulls are not really values - they represent the absence of a value, not its presence.

Example:

Private Sub SomeCombo_AfterUpdate()
    If Me.SomeCombo = TriggerValue then
        Me.AnotherControl = Null
    end if
End Sub

Setting fields to null can be done similarly in SQL if you are using an Update query.

-Stewart

[ADezii]

@Resmy Ravi
http://bytes.com/topic/access/insights/716197-what-null