Text Field size and enter key behaviour (1 Viewer)

[neileg]

If you create a table in Access, the default length of a text field (unless you have altered the options) is 50 characters. If you import a file from Excel, the default size for a text field is 255 characters.

When you run the form wizard on a table that has a text field of 255 characters, the enter key behaviour is set to 'New line in field' on the resulting text box.
When you run the wizard on a text field of 50 characters the enter key behaviour is set to 'Next Field'.

Anyone explain these 'features' and can you tell me at what length the enter key treatment changes!

 

[dgm]

You can use the EnterKeyBehavior property to specify what happens when you press ENTER in a text box control in Form view or Datasheet view. For example, you can use this property if you have a control bound to a Memo field in a table to make entering multiple-line text easier. If you don't set this property to New Line In Field, you must press CTRL+ENTER to enter a new line in the text box.

It seems that the default setting is for values up to 60, and the New line setting is for any value over 60...