T
Ted
You can also use the Nz() function, which has two parts.
The first part would be the value that you want to list,
the second part contains a number or string that you want
to return if the source value is null.
For example: Nz([YourFieldName],"Unknown Value")
-Ted
it with a string such as "Unknown value". I would like
to do this as part of an SQL query which poulates the
rowsource of a list box. I do not want to update the
underlying data, the "Unknown value" text is for display
purposes in the list box only.
The first part would be the value that you want to list,
the second part contains a number or string that you want
to return if the source value is null.
For example: Nz([YourFieldName],"Unknown Value")
-Ted
of a field to see if it is NULL and if it is then replace-----Original Message-----
Hi,
I have a situation where I would like to check the value
it with a string such as "Unknown value". I would like
to do this as part of an SQL query which poulates the
rowsource of a list box. I do not want to update the
underlying data, the "Unknown value" text is for display
purposes in the list box only.