Displaying Text field from linked Excel table in reports

[Sacapuce]

Hello,
I have built a report based on a simple query with 2 tables, one being an
Excel linked table (no group by option, no sorting, no order by).

One of the text field from the linked Excel spreadsheet contains text up to
300 caracters. In Design mode, it is set as text (255) format @.

When I add it to my report and try to view it, I get the following error
message: "the field is too small to accept the amount of data you attempted
to add. Try inserting or pasting less data".

I set the field property to can grow (yes) and put no format in the format
property box. Still nothing works. Strangely, it works when I create a
report based on the linked table only. Unfortunately, I need the second
table as it enables me to select the subset of the linked table that I am
interesting in printing.

Any idea how I could sort this out?
Many thanks
S

 

[Golfinray]

You would probably have to split that 300 character record in two or make it
a memo field. I think text fields are limited to 255 but memo fields are not.

 

[Sacapuce]

Thanks but the field is from a linked Excel table over which I have no
control therefore I cannot change the format to Memo.
Still it does not explain why it works when I create a report with the Excel
fields only and it does not when it is based on a query with 2 tables with a
join.

 

[Sacapuce]

A 'dirty' way of doing it is obviously creating a sub-report but still there
should be a way...I must be missing something obvious!