[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines


Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index
What is MS Access


How the User can Move to a New Line in a Memo or Text Field

Question

“The application I'm currently building has a table of memo objects. The users should be able to create memos from a form, and when they are writing the memo, the return key should give them a carriage return rather than take them to the next field. I know that will do this but I would prefer not to go this route.”

Answer

To enable the user to move to the next line in a text or memo field, complete the following:

With the form in Design view, double click on the text or memo box that you wish to set this option for;

Double clicking opens the Property window;

Click on the ‘Other’ tab and make sure the ‘Enter Key Behaviour’ says new line in field;

This should be the default for the memo field (in the later versions of Microsoft Access), but you will need to change it for a text field.

 

Do you like this tip? Subscribe to my weekly Newsletter to receive tips weekly via email. Click Here to subscribe.

footer for Microsoft Access page