Accommodating carriage return in text field

[wjoc1]

Hi,

This should be a really quick one for you guys...

I read somewhere that Access catches carriage returns in a text field so that even for addresses that will contain more than one line, I can still catch them in a single field and they will display as multi-line values.

However when entering the address in the control on a form it keeps jumping to the next control every time I hit return.

 

[Mile-O]

Change the textbox's Enter Key Behavior property.

 

[wjoc1]

Thanks SJ worked a treat

Liam