Hi thanks for your reply.

IsNull() function in MS access checks whether the values is null or not.

But I want it in a way that if it is Null i'm going to replace it by ~.

Something like IsNull(FieldName,'~') that we use in SQL Server.

Is there a function equivalent to that besides Nz(fieldname, '~') in MS Access?