|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 28th, 2005, 03:13 PM
|
|||
|
|||
Show Nulls in a table
Is there a way to have nulls appear in a table, for example like in SQL the
field value shows as NULL ? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200510/1 
|
|
#2
October 28th, 2005, 03:18 PM
|
|||
|
|||
|
Show Nulls in a table
Not really. You could do it in your table, query, or report by using the Nz
function... Nz([Somefieldname],"NULL") -- Rick B "sweetlisa1217 via AccessMonster.com" u14343@uwe wrote in message news:56843f6105ed3@uwe... Is there a way to have nulls appear in a table, for example like in SQL the field value shows as NULL ? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200510/1
|
|
#3
October 28th, 2005, 03:29 PM
|
|||
|
|||
|
Show Nulls in a table
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" Anonymous wrote in message ... Not really. You could do it in your table, query, or report by using the Nz function... Nz([Somefieldname],"NULL") -- Rick B "sweetlisa1217 via AccessMonster.com" u14343@uwe wrote in message news:56843f6105ed3@uwe... Is there a way to have nulls appear in a table, for example like in SQL the field value shows as NULL ? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200510/1
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
| Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
| Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
| Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
| Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Linear Mode
