Some versions of Excel have a 255 character limit.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"oasd" <g45340@hotmail.com> wrote in message
news:428bb9cd$0$5176$afc38c87@news.optusnet.com.au ...[color=blue]
> Is there any way to increase a text type field size to more then 255
> characters?
> I tried Memo type field but i'm having difficulty exporting all text data
> entered into this field (for respective records) to an excel spreadsheet.
> Only a portion of text gets exported successfully into the excel
> spreadsheet. I don't know why.
>
>[/color]
