DoCmd.OpenReport does not work with ASC in where condition

[PNC]

Hi,

This is my code

DoCmd.OpenReport stDocName, acPreview, , "ASC([Field]) like ASC("'Variable'")"

ERROR: Data type mismatch in criteria expression

It works fine in a query, therefore it should also work in the code, right?

Any ideas why not?

Thanks,
PNC.

 

[earthandfire]

ASC returns the character (ASCII) value ie a number, which you are comparing to a string. eg ASC("A") returns 65 which doesn't equal "65

 

[PNC]

But Field is a string, so is the variable...

DoCmd.OpenReport stDocName, acPreview, , "ASC([Field]) like ASC("& Variable &")"

Is it because sometimes the [Field] might be null?

Any ideas, anyone???

Thanks,
PNC.