HOW TO : Show NULLs in Table View
HOW TO : Show NULLs in Table View
(OP)
I know SQL_Server does it.
Is there an MS_Access option that'll show NULL fields as something other than blank?
Zero-Length would look like " "
Space would look like " "
NULL would look something like "<<null>>".
I have a DB with poor NULL handling and it would be a huge research help...
Is there an MS_Access option that'll show NULL fields as something other than blank?
Zero-Length would look like " "
Space would look like " "
NULL would look something like "<<null>>".
I have a DB with poor NULL handling and it would be a huge research help...
RE: HOW TO : Show NULLs in Table View
0.00;(0.00);0;"Null"
I expect this doesn't work for text field but you can use Conditional Formatting.
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
RE: HOW TO : Show NULLs in Table View
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016