Hi Sergey,

is there any reason why you don't use NVL()?

lcFieldValue = nvl(lcFieldValue,'')

>Hi Nick,
>
>You have access to the source code for GenHtml and _html.vcx and may adjust it to your liking.
>The small change below should fix the problem but I didn't test it. It should get you started, though.
>

>* _html.vcx, _htmltable class
>* GenerateListTable method
>* GenerateDetailTable method
>...
>		lcFieldValue=this.GetFieldValue(lcField,this.aFieldList[lnCount,2], ;
>				this.aFieldList[lnCount,3],this.aFieldList[lnCount,4])
>
>		* Commented current code skips null values
>		*IF ISNULL(lcFieldValue)
>		*	LOOP
>		*ENDIF
>		* Try
>		IF ISNULL(lcFieldValue)
>			lcFieldValue = ""
>		ENDIF
>...
>

>>I am reading an Excel spreadsheet using ADO over OLEDb which I then write out to a webpage using GenHTML. Problem is all blank cells in the spreadsheet get imported as .null., unfortunately GenHTML simply ignores null fields and moves the rest of that record to the left, hence the fields do not match the column headings.
>>
>>Anyone suggest how to concert all these nulls to blank or space without reading through each field of each record, or any other ideas how to solve this one?
>>
>>Cheers