Line Break in Textbox

[alyon]

In Access 2007, can someone tell me how to populate a textbox with a line break?

=[Forms]![Violations]![cboSection4] & i want the line break here & [Forms]![Violations]![cboSection5]



I feel like this should be simple, but I can't figure it out.
Thanks for the help!

[June7]

=[Forms]![Violations]![cboSection4] & Chr(13) & Char(10) & [Forms]![Violations]![cboSection5]

[rpeare]

the code is & vbcrlf & (VB carriage return line feed pair)

[June7]

vbCrLf won't work in a control (textbox, listbox, etc), at least not in my test effort

[boblarson]

vbCrLf won't work in a control (textbox, listbox, etc), at least not in my test effort

That is completely correct. vbCrLf is ONLY good in VBA. Control sources or in queries you need to use Chr(13) & Chr(10) and it is good to note that it needs to be in that order (just in case someone missed it).

[alyon]

Chr(13) & Chr(10) works perfect! thank you! :]

[merlin777]

Chr(13) & Chr(10) works perfect! thank you! :]

I hope its not too late to ask' is there a way to do this without code (e.g. in excel it's 'ALT-ENTER')

[accessnewbie352]

I hope its not too late to ask' is there a way to do this without code (e.g. in excel it's 'ALT-ENTER')

This is probably a bit too late given the time the question was asked but i stumbled on this when googling the answer myself. I used "Ctrl" + "Enter" directly in the text box via the design view and it worked.

[rgi]

I found that the text format affects whether the Chr(13) & Chr(10) works or not. (i.e. Text Format = Plain Text works, but Rich Text does not) Ctrl + Enter in 2010 had no affect by itself, but only made it more readable in the textbox.

This is probably a bit too late given the time the question was asked but i stumbled on this when googling the answer myself. I used "Ctrl" + "Enter" directly in the text box via the design view and it worked.