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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOW TO : Show NULLs in Table View

Status
Not open for further replies.

cp950

Programmer
Dec 18, 2000
19
0
0
US
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...

 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top