Memo field - using the enter key

M

Mike

Hi folks,

I'm working on my first database, for tracking our clients. One of the
fields I need is a memo field for keeping counseling notes. I want for our
counselors to be able to type random notes into this field with whatever data
they need to input for our clients.
However, when I am in this field and type a sentence and hit "enter" to move
to a new line, it instead adds the record and takes me to the next record to
start over. This is not the behavior I want, I want to be able to type
sentences, even paragraphs into the memo field and have the "enter" key go to
the next line in the memo field, not skip me to a new record.
I'm sure this is a very simple fix, but I haven't figured out the formatting
just yet. Any advice?

Thanks,
Mike
 
R

Randy

Mike said:
Hi folks,

I'm working on my first database, for tracking our clients. One of the
fields I need is a memo field for keeping counseling notes. I want for
our
counselors to be able to type random notes into this field with whatever
data
they need to input for our clients.
However, when I am in this field and type a sentence and hit "enter" to
move
to a new line, it instead adds the record and takes me to the next record
to
start over. This is not the behavior I want, I want to be able to type
sentences, even paragraphs into the memo field and have the "enter" key go
to
the next line in the memo field, not skip me to a new record.
I'm sure this is a very simple fix, but I haven't figured out the
formatting
just yet. Any advice?

Thanks,
Mike

There is a property called "Enter Key Behavior", I believe selecting "New
Line in Field" will give you the result you are looking for.
 
J

Jeanette Cunningham

Mike,
there is a property called Enter Key Behaviour - its default value is
determined by your settings on the database Tools,Options, for Keyboard,
Move after enter.

You can set to go to a new line for the memo field like this:
Select the memo field (design view of form), on the properties dialog, go to
the tab called Other, find the property called Enter Key Behaviour, click on
the drop arrow and choose New Line in field. Save the form.

Jeanette Cunningham
 
M

Mike

Randy,

Thank you that is what I needed.

Mike


Randy said:
There is a property called "Enter Key Behavior", I believe selecting "New
Line in Field" will give you the result you are looking for.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top