Having trouble with Truncation

macropod · #4 07-12-2018, 08:41 PM

Quote:

Originally Posted by Drakos

I am using VBA to iterate through the data source and produce the report, everything is working fine except one thing, any of my data Fields that are longer the 255 characters are being truncated to 255 characters.

I find this strange because everything comes out fine if I use the same data source for an actual Mail Merge.

That suggests your process is treating those fields as text fields, whereas they need to be treated as memo fields.

That said, without seeing either the data source or the intended output, it's impossible to confirm your assessment that mailmerge can't be used.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
trouble with code	gummybear	Excel	3	04-19-2018 12:26 PM
Trouble with me animations	Halesowenmum	PowerPoint	5	11-21-2017 04:14 AM
Trouble with Hyperlinks	DanielMcCrea	Word	1	09-27-2017 02:35 PM
I'm having trouble doing these tasks	jackmackfack	Word	4	02-19-2015 06:46 PM
Macro trouble	Zack	Excel	2	10-14-2010 12:07 PM