Show Nulls in a table

[sweetlisa1217 via AccessMonster.com]

Is there a way to have nulls appear in a table, for example like in SQL the
field value shows as <NULL> ?

 

[Rick B]

Not really. You could do it in your table, query, or report by using the Nz
function...


Nz([Somefieldname],"<NULL>")

 

[Duane Hookom]

Since you should always view your data in forms and reports, you can set the
format property to display Nulls as anything you want.

--
Duane Hookom
MS Access MVP
--

Not really. You could do it in your table, query, or report by using the
Nz function...


Nz([Somefieldname],"<NULL>")