Query to append controls into Memo field

[3Mark3]

Hello all,
I'm trying to figure out how to add a return when pasting several controls into a memo field.

what I'm trying to do is add return lines after each field. For instance:

[Control1]
[[Control2]
[Control3]



When I'm creating the query, I use:

[Control1]+[Control2]+[Control3]


How can I configure adding the return part of what I'm trying to do?

Any help would be greatly appreciated, thank you!

 

[PHV]

[Control1] & Chr(13) & Chr(10) & [Control2] & Chr(13) & Chr(10) & [Control3]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[3Mark3]

Thank you. Oddly it's not working right for me. It's showing everything on the same line with Squares between each piece of data. This is a memo field, does that have anything to do with it?

Here's how my query looks:

t_notes: [temp_table_MI]![t_notes] & Chr(10) & Chr(13) & "Topics Discussed:" & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_1] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_2] & Chr(10) & [temp_table_MI]![t_discussed_3] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_4] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_5] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_6] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_7] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_8] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_9] & Chr(10) & Chr(13) & [temp_table_MI]![t_discussed_10]

Is it my query that's not setup right?

 

[PHV]

You inverted 10 and 13

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886