set value to <null>

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...


Delete the contents of the field (Backspace or Delete button).
Or do you mean for it to actually say "<null>"?
 
I tried that and it creates a zero length value but that is not the same as a
Null value.
Click to expand...


To clarify - is this in the table itself, or on a form? If a form, is
it bound to a recordsource?
 
Sorry, I should have stated that in the orig post, this is in the table itself.
Click to expand...

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.
 
Back
Top