HOW TO : Show NULLs in Table View

cp950 · May 10, 2018

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

dhookom · May 10, 2018

For numeric fields displayed in text boxes on forms you can use the format property like:
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

dhookom · May 10, 2018

I just realized you specified "table view". The options I suggested will work in datasheet view which is similar to table view.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

HOW TO : Show NULLs in Table View

cp950

Programmer

dhookom

Programmer

dhookom

Programmer

Similar threads

Part and Inventory Search

Sponsor