>Thanks for the help , Gar. But the problem i have is different. I give the user "n" number of columns to choose from out of which any field could be of type memo. So I dont have a preset field, which i can test for memo. The user could choose either 1 field or 50 fields from various table i show him. So any one or more of these fields could be memo. Thats why i have this problem.
>
>Thanks once again.
>
>Dinesh

Obviously the user passes back the names or numbers of the field in some way, and then you do the export. So at some point before you do the export you have, or can get the names of all the fields the users has selected.

Just use the Type command to determine which of these fields are memo and do the conversions.

Or use the active x trick, and then you don't need to know the field type and have no problem.