Access 2000 mdb - large memo fields show up as blanks on report

[Former Member]

I have an Access 2000 mdb that has several large fields defined as memo.  I need to convert these to string[65534] since as memo fields they show up as blanks on my report. Can you please tell me if, within CR, this can be done and how to do it?

[former_member183750]

You can not convert a memo field to a text string. A string after x number of chars is considered to be a memo anyhow.

What version of CR are you using?

How are you connecting to the db - ODBC / Native, etc.?

Oh - please be precise on the version of CR. E.g.; CR XI is not quite good enough.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Message was edited by: Ludek Uher

[Former Member]

I am using the 2103 Evaluation version of CR (which I was told is the full version).

I am connecting to the Access mdb using DAO. (I tried using ODBC (RDO) but can't get it to work.)

I am able to see other fields in the preview of my report including small fields defined as memo fields - but the large field I have is blank on the report.

I am not able to browse any memo field in Field Explorer.

[former_member183750]

Oh, wait. There is a difference between this:

memo fields they show up as blanks

and this:

I am not able to browse any memo field in Field Explorer

The first one I interpreted as that when the field is placed on the report and the report previewed the field is blank.

The second description is much different. E.g.; when I right click on a memo field in the designer I do nto have the option to browse the field at all. This is an expected behavior. Now a small memo field (< 254 characters) may be interpreted as a string so this may be "browsable".

- Ludek

[Former Member]

The real problem I have is that I need to be able to display these large fields in my report.

Maybe I should not have mentioned the fact that no memo fields are "browsable" with Field Explorer.

I thought that this was probably not as it should be - as least for small fields - but I don't have to have this.

You are correct when you say:

"The first one I interpreted as that when the field is placed on the report and the report is previewed the field is blank."

This is the problem I have to solve.  I have to be able to display these fields in my report.

Can you help me to do that?

[former_member183750]

Ok, so the problem is this:

You drag a large memo field into a section of the report, say a detail and you get no data?

Small memo field works.

If that is the case, can you define large and small memo fields?

- Ludek

Oh. And try ODBC or native please.

Message was edited by: Ludek Uher