Query to show results is Null then show... (1 Viewer)

[Number11]

Hi, so is it possible to have a query show a default wording when the results found are NULL. I just dont want to have black fields maybe "No Record Found"

 

[jdraw]

IF IsNull(someField) then
msgbox "No Record Found"
end if

 

[Isaac]

Or inside the query:

ColumnAlias: nz([ColumnName],"No Record Found")

 

[Number11]

Or inside the query:

ColumnAlias: nz([ColumnName],"No Record Found")

ok so this would work and show No Record Found if the results in that column were null, but if that had a result it will still allow the data say like "Ordered"

 

[Isaac]

Yes

 

[Pat Hartman]

Keep in mind that doing something like this changes the data type of the column to a string so numbers and dates may not work the way they should.

"Empty" fields should ALWAYS be null so I would never substitute a string value. That just messes up other stuff.