Multiple records in textbox

[matg]

Hi,

I'm fairly new to Access and VBA.

I've designed a database for work to record student responses from customer service-style questionnaires. Most of these are Yes/No responses and easy to analyse using the =Count(Iif function in Access Reports.

One of the responses however is a comment box. I've recorded the comments in each record but want to display all of these at once in one text box. Is this possible?

I've put everything in the Report Footer.

 

[RuralGuy]

Have you looked at this thread yet?

 

[matg]

Hi RuralGuy

I had already looked at that thread and I couldn't make it work. It seems to relate to different fields in the same record - I'm looking to include one field from different records. Are you able to show me an example of how this would affect the code in that thread?

Many thanks

 

[RuralGuy]

The function that DCrake created in post #8 of that thread returns three different fields from *all* of the records in the table put into one string.

 

[matg]

Hi RG

I tried many variations of the function and still could not make it work. I will try again tomorrow morning when I am back in the office in case I have overlooked something.

Thanks

 

[RuralGuy]

If you post the code for your function, we might see something.

 

[LeeInEngland]

You could concatenate all of the responses into one mighty text box.
Perform a loop through each record and append the new comment onto the existing comments. e.g. txtAllComments = txtAllComments + " " + table1.ThisComment