Display an string when a field is null

[t16turbo]

hi there,
I am writing a report that lists all projects that have certain information that has not been populated.
There are 7 fields, and the SQL uis a simple SELECT <all 7 fields> FROM <table> WHERE <fied 1 IS NULL OR field 2 IS NULL etc>

What I want to be able to do is show "NULL" where a field is blank, or highlight the field a certain colour.
any suggestions?

 

[PeteWalburn]

Hi,

Change the SQL to:

Select nvl(<field1>,'NULL'),nvl(<field2>,'NULL'),nvl(<field3>,'NULL'),(<field4>,'NULL'),(<field5>,'NULL'),(<field6>,'NULL'),(<field7>,'NULL') FROM <table> WHERE <field1 IS NULL etc>

Pete

 

[PeteWalburn]

Hi,

Or you could override the OnRow event of each of the <field1-7> controls. Somthing like:

Sub OnRow( row As AcDataRow )
Super::OnRow( row )
if IsNull(row.getvalue("<field1>")) then
font.color=Red
end if
End Sub

Pete