The code below works well to put the contents of a text field into my PowerPoint table.
Expand|Select|Wrap|Line Numbers
- .Cell(lngY, lngX).Shape.TextFrame.TextRange.Text = RSTravelSch_DTRI_ABS_Query6.Fields("Attendees").Value
In access, this field is a pull-down where you can select multiple attendees for a single event. The table field is a standard lookup table
Expand|Select|Wrap|Line Numbers
- SELECT Attendees.[ID], Attendees.LastName, Attendees.FirstName FROM Attendees ORDER BY Attendees.LastName;
For example: "Jones, Smith, Carloson, Robinson"
Help!!