S sweetlisa1217 via AccessMonster.com Oct 28, 2005 #1 Is there a way to have nulls appear in a table, for example like in SQL the field value shows as <NULL> ?
Is there a way to have nulls appear in a table, for example like in SQL the field value shows as <NULL> ?
R Rick B Oct 28, 2005 #2 Not really. You could do it in your table, query, or report by using the Nz function... Nz([Somefieldname],"<NULL>")
Not really. You could do it in your table, query, or report by using the Nz function... Nz([Somefieldname],"<NULL>")
D Duane Hookom Oct 28, 2005 #3 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 -- Rick B said: Not really. You could do it in your table, query, or report by using the Nz function... Nz([Somefieldname],"<NULL>") Click to expand...
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 -- Rick B said: Not really. You could do it in your table, query, or report by using the Nz function... Nz([Somefieldname],"<NULL>") Click to expand...
