set value to <null>

[Guest]

Is there a way to set a field to a value of <null> manually using the
keyboard? In SQL Enterprise Manager I can type Ctrl+0 to get a null value.
Is there anyway to do this inside MS Access?

 

[storrboy]

Is there a way to set a field to a value of <null> manually using the
keyboard? In SQL Enterprise Manager I can type Ctrl+0 to get a null value.
Is there anyway to do this inside MS Access?

Delete the contents of the field (Backspace or Delete button).
Or do you mean for it to actually say "<null>"?

 

[Guest]

I tried that and it creates a zero length value but that is not the same as a
Null value.

 

[storrboy]

I tried that and it creates a zero length value but that is not the same as a
Null value.

To clarify - is this in the table itself, or on a form? If a form, is
it bound to a recordsource?

 

[Guest]

Sorry, I should have stated that in the orig post, this is in the table itself.

 

[storrboy]

Sorry, I should have stated that in the orig post, this is in the table itself.

I've never thought about or come across this need. I don't know of a
key combination to enter a Null value. The only time my suggestion
dosen't work for me is when the field contains an empty string to
begin with, in which case if it were a problem, I would set the
AllowZeroLength on the field to No.