How to export more than 256 charachters in MS access report ?

[Sharat K Patra]

Hi friends,

I have one MS access VBA application. For the report MS access report design (MS access 2003)is used and data source is Ms Sql sever 2005. In a report I want to export more than 256 characters in the excel report. Report is coming fine but the filed is truncated with 256 characters.

Can anybody help me on this to export more that 256 character in the excel report ?

Thanks in Advance!

Sharat

[jimatqsi]

Sharat,
Welcome to Bytes.

You say "the file is truncated", but do you mean some individual field is truncated? If so, what is the field, a memo? What code are you using to do the export?

Give us some more details, please

Jim