Hard returns for data type varchar

[Guest]

I have a field in a SQL Server table with type varchar(2550). In Access, I
have a form to enter data into this table. I will sometimes want to enter a
new line in the form field.

Is there a way to enter a hard return on this field, or will I just have to
use the text wrap function?

tia

 

[Rick Brandt]

I have a field in a SQL Server table with type varchar(2550). In Access, I
have a form to enter data into this table. I will sometimes want to enter a
new line in the form field.

Is there a way to enter a hard return on this field, or will I just have to
use the text wrap function?

Either use Ctl-Enter or set the EnterKeyBehavior property for the TextBox
on the form to "New Line in Field".

 

[Guest]

This works perfectly. Thanks!

Either use Ctl-Enter or set the EnterKeyBehavior property for the TextBox
on the form to "New Line in Field".