disable multiline in textbox

[nicholas]

Hi,

In a form, when inserting a textbox, it is a multiline texbox.
Ex: when press on "return" a new line is created.

How can I disable this multiline option of the textbox.

I'ld like that when I press on return or enter, that the cursor goes to the
next textbox (just like press on tab).

Any Ideas ?

Thx !!
Nic

 

[John W. Vinson]

Hi,

In a form, when inserting a textbox, it is a multiline texbox.
Ex: when press on "return" a new line is created.

How can I disable this multiline option of the textbox.

I'ld like that when I press on return or enter, that the cursor goes to the
next textbox (just like press on tab).

Open the Form in design view. Select this control; view its
Properties. Change the "Enter Key Behavior" to "New Record".

Save the form and see if that solves the problem.

Note that users can still type Ctrl-Enter to force a new-line into the
field.

John W. Vinson [MVP]

 

[nicholas]

Hi,

Thx for your reply.
Access doesn't accept "New Record".
It says I should select something from the list (options are: default or new
line in field).

Any other idea?

Thanks a lot!

 

[Josh D]

On the database menubar select Tools>Options and select the *keyboard* tab.
There select the radio button that controls behavior of the *Move After
Enter* to the desired effect that you are looking for.

 

[John W. Vinson]

Hi,

Thx for your reply.
Access doesn't accept "New Record".
It says I should select something from the list (options are: default or new
line in field).

Sorry... use the default. It is apparently currently set to "new line
in field" - which is not what you want; so choose the other one.


John W. Vinson [MVP]

 

[nicholas]

Thanks, both of you.

I checked all this and it indeed works...on a windows xp, but not on my
windows 2000.... weird.

Thanks anyway,
Nic