Data mismatch error in Access report

[ragpatil]

Hi ,

I am having a texbox in the report and I have set the control source to a Field from the query which is set as control source for the report.
Now when there some null values in this field , I am getting the error Data mismatch .

Please provide some suggestions how we can handle this.



Thanks in advance.

[JoeM]

Are these fields with nulls being used in relationships/linking the tables or in criteria/filters?
You may want to address the NULL values and convert them to something using the NZ or ISNULL functions.

[ragpatil]

Are these fields with nulls being used in relationships/linking the tables or in criteria/filters?
You may want to address the NULL values and convert them to something using the NZ or ISNULL functions.

Thanks for the reply .

I am setting the value of text box in the Control Source as
=(Space(3) & IIf([typeReturn]="T",[ipaydate1],""))

So here if ipaydate1 is null , I am getting the error

[JoeM]

Try:
=(Space(3) & IIf([typeReturn]="T",NZ([ipaydate1],""),""))

[ragpatil]

Thanks a lot .

After using Nz function also I am getting the same error .
When I tried to put data in those field ipaydate1 in table , I am able to see the report.

Kindly provide some suggestions.

[JoeM]

Can you post the SQL code of your query?

[Rainlover]

Does the Field [typeReturn] have Null values and do you get the error on these records.

[ragpatil]

Hi,
typereturn is also contains null values .

I also tried by setting the control source with = Nz([ipaydate1],"").
Then also I am getting the same error.

And the ipaydate1 is a text field.

[Rainlover]

If TypeReturn has Null values then you need to give it a value. Try If(Nz(TypeReturn),0) etc

[Rainlover]

EDIT

If TypeReturn has Null values then you need to give it a value. Try If(Nz(TypeReturn),0) etc


IIf(Nz([typeReturn],0) = T,[ipaydate1]," ")

Is this the correct spelling "ipaydate1"


The above is untested.