Data mismatch in Report

[ragpatil]

Hi ,
I am also getting same error Data mismatch in Access report 2003.
The issue is ,I have a textbox control in the report and I have set the control source of this textbox to field from a Query .
When the output of the field is null, i am getting this error.


Please provide some solution how to handle the null values.

Thanks in advance.

[ssanfu]

@ragpatil - You should start your own thread for several reasons

- you have "hi-jacked " the thread by jimmy_bones (frowned upon)
- If jimmy_bones marks the thread solved, no one will see that you have posted a question and still need help.
- You (and everyone else) can find your post easier.

[RuralGuy]

Steve: I moved it to a new thread.

[ssanfu]

Allan -

@ragpatil - I have never seen where a bound text box has caused an error when the bound field is NULL.
What is the result if you execute the query by itself?
Do you still get the error?
Is the bound field part of the WHERE clause of the query?