Question Locked
Access .ConvertToTable() and newlines
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?