Avoid that Enter close record in memo fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't use forms in Access very much, mostly the database. But sometimes I make a fast form for creating some records in a table. This works fine for one thing. When I have a memo field, I am used to Enter inserting a new line and in other fields accepting the record being updated (usually by and Ok button being default). However, in the Access forms Enter always accepts the record and opens the next one, even in memo fields. You have to use Ctrl + Enter to get a new line.
Is there a setting that will generally make Access insert a new line instead of closing the record, or does it have to be programmed for each form, and if the latter what would be the easiest way of doing that?


Regards,

Frank M.
 
Yes, look at the properties for the control & goto the Other tab. Under the
'Enter Key Behaviour' property you can configure this to move to the form
default, or act as the newline char...


--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
Frank M. said:
I don't use forms in Access very much, mostly the database. But sometimes
Click to expand...
I make a fast form for creating some records in a table. This works fine for
one thing. When I have a memo field, I am used to Enter inserting a new line
and in other fields accepting the record being updated (usually by and Ok
button being default). However, in the Access forms Enter always accepts the
record and opens the next one, even in memo fields. You have to use Ctrl +
Enter to get a new line.
Is there a setting that will generally make Access insert a new line
Click to expand...
instead of closing the record, or does it have to be programmed for each
form, and if the latter what would be the easiest way of doing that?
 
Back
Top