Access .ConvertToTable() and newlines

By terry.walters ·
Having collated the data in Access 2002, I output the results in Word using Bookmarks in a template.
The .ConvertToTable() function works very well until the user enters either a '-' or a 'newline' into the text box in Access. The conversion then throws a wobbly and doesn't create the correct number of table columns.
I suspect that these are special control characters for the routine, but to use a newline in a text box is not unreasonable. has anyone overcome this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums