Multiple records in a field. (1 Viewer)

[Tracy]

Hello, can anyone please help as I've completely run out of ideas!

I have a text box in a report footer, and in that single text box, I need to display all the records in a table. The table has around 5 records in it.

I can create a string concatenating all the records. That's no problem, but how can I display it in the field using a carriage return after each record, so that they all appear in a column underneath one another?

I tried:

strRecords = strRec1 & chr$(13) & strRec2 & chr$(13) & strRec3

but the chr$(13) just shows a symbol even though it's the character code for a carriage return.

Any ideas anyone?
Thanks
Tracy

 

[Jon K]

Try this:-

= strRec1 & chr(13) & chr(10) & strRec2 & chr(13) & chr(10) & strRec3


i.e. a carriage return and a line feed

 

[Rich]

Since your in vba you can also use & vbCrLf &

 

[Tracy]

Thank you bot for your help. Works a treat!
Tracy

 

[Tracy]

And finally....

Any ideas on how to create a second column in the same field (poss using chr(??)).

Thanks
Tracy

 

[sambo]

Insert another text box to the right of your existing one and fill this with the other values.

Better yet, just use a continuous form and format the controls however you want.

Rich.. I'm surprised you didn't suggest this given your history for contempt towards inefficiency.