VFP .NULL.

[Emetsky_(Guest)]

Hello folks!____I^m storing .NULL. values in my VFP data tables (dbf) and I want to format the .NULL. to show NA on the report.____IIF(field=.null.,^NA^,field)____Is this possible in R&R v8.1?____TIA,__Emetsky

[kfleming]

R&R is not able to distinguish an explicit foxpro null from a blank field. For logical nulls, we read the field as .F.__You can use the isblank function to test for a blank and return a value. Because you want to print ^NA^ for an empty field you would need to do a data type conversion for numeric or date fields. __So the expressions would be:____IIF(islblank(field),^NA^,field) __IIF(islblank(field),^NA^,str(field)) __IIF(islblank(field),^NA^,DTOC(field)) ____Kathleen__R&R Support