Code to vbcrlf when the enter button is pressed?

[neemi]

Access 2000.

I have a simple form with a text box. I was wondering if anyone knows how I would write code so that when the User press's the enter button a vbcrlf is inserted (a new line is entered) if they have focus on the text box in question, and where I would insert this code.

At the moment when they press enter they are taken to the next control on the form.

Help appreciated.

Cheers

Neemi

 

[RobBroekhuis]

You need to make sure that the following two properties of your textbox control are set appropriately:
.multiline=true
.enterkeybehavior=true
Do that, and Excel/VBA does the rest.

Rob