[RESOLVED] Invalid use of Null

**shakti5385** · Dec 22nd, 2006, 02:40 AM

VB Code:

IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage), "'", ""))

**Kuamr** · Dec 22nd, 2006, 02:50 AM

Hi Shakti,

Originally Posted by shakti5385

VB Code:

IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage), "'", ""))

if a remove the last bracket i.e ")" it gives a complie error saying
"argumetn not optional "

and the replace function is higlighted

Thread: [RESOLVED] Invalid use of Null