Textbox in Form with Default Values

[Excel_77]

Hi,

I have a textbox within a form that feeds from a spreadsheet. One of the fields within the spreadsheet is blank, however on the form the value "FALSE" and sometimes "0" appears. I would prefer this box remains blank until such times as the spreadsheet is populated - is this possible?

Thanks

 

[alansidman]

Perhaps using the NZ function in the control. Look at this link. https://www.techonthenet.com/access/functions/advanced/nz.php