If you want to show spaces instead of zeros on VFP screen form then you should use Textbox.Format='Z' for all appropriate fields.
>yes,
>i convert this table to excel sheet, i found many records have zeroze...
>
>>You cannot fill space to numeric field. Maybe you want to show blank on screen when table field value is zero?
>>
>>>thank you for reply,
>>>i mean i have many fileds at mytable this field have numbers or sero,
>>>i want to replace space(blank) for zero
>>>thanks
>>>>>hi all,
>>>>>i need to replace space to my table where i found zero?
>>>>>
>>>>>USE mytable
>>>>>SCAN FOR FIELDS=0
>>>>>REPLACE ALL FIELDS WITH SPACE()
>>>>>ENDSCAN
>>>>>
>>>>>thanks
>>>>
>>>>What means Fields=0 ?
>>>>Anyway, you should look at BLANK command.
Edward Pikman
Independent Consultant