Hexadecimal Data on Report

[lynchg]

I am using CR 9 with Access 97 queries as the data sources for a report with several subreports. One of the string fields on one of the subreports is displaying data that looks like it could be the hex version of the output. This is a string field with people's names in it and instead of seeing the name I am getting a string of mostly numbers in what appears to be four characters per letter of the name.
Some examples:

P - 5000
L - 4c00
E - 4500
N - 4e00

Help!

 

[synapsevampire]

Hard to say, you need to know/share what the data type is in the Access database.

Perhaps you can create an Access query which converts the data into a conventional string type, and then base the CR report off of that query.

-k

 

[lynchg]

The field in the Access db is and always has been a string field. The report has always been based on a query.

I hadn't previously done anything in the query to convert what was already a string value into a string value, but I tried what you suggested and it made no difference.

The query that originally fed the report was a union query. I nested that union query into a select query and the result was the same.

Does anyone have any ideas, have you seen this behavior before?

 

[synapsevampire]

Very strange indeed...

Try shrinking it using a LEFT or MID in an Access QUery, does it return the right data then?

What connectivity are you using?

Try changing it to use another type or driver.

-k