.Null how to get rid of it 1

[lashwarj]

n my database I have fields that will have no value all the time and everytime there isnt a value I get the famous .null in place of no value, how do I remove this

 

[foxdev]

If you are using a database, you could make the default something like '' (for character fields).

If its the display of .NULL. that bothers you, you can use SET NULLDISPLAY to make it appear as an empty string or message such as (not entered). Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[lashwarj]

How do I do the nulldisplay , as far as setting it to "" or Not entered

 

[foxdev]

Generally:
SET NULLDISPLAY TO ""

Alternatively, for each control on a form you can set its NullDisplay property to the desired value. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org