title: MS Access datasheet view does not display nulls?
body: <p>Is there a way in MS Access (2007) to display null values (opposed to empty strings) from the datasheet view.</p>
  
  <p>Progmatically SQL is inserting hard coded null values without error and the column property "Allow Zero Length" is set to No, so I thought a null value would be inserted  but when viewing the table within MS Access it appears as an empty string.</p>
  
  <p>Is a null being inserted?</p>
  
  <p>Does MS Access not display 'null' as a value or keyword??</p>
  
  <p>Is there a setting I need to change to view nulls?</p>
  
  <p>This is leading to confusion and is becoming a real pain!</p>
  
  <p>Any ideas welcome, thanks.</p>