Create area to enter detail information 1

[needadvice]

I have an inquiry screen where I want the user to have the capacity to input extensive details about a record.
I tried putting a button on the screen which when clicked opens another form. On that form I put a memo text field and expanded it to the length of the screen.
The problem with this method is whenever you hit 'enter' or 'tab' it goes to the next record and the field goes blank.
The user wants this area to respond like a word processing screen where enter drops you down to the next line instead of out of the current record.

What would be a better way to achieve this? Please remember, this data needs to be saved and retrieved with the associated record when queried.
Thanks

 

[willir]

A memo field works with the <Enter> representing a new line.

An alternative solution, with more over head, would be to use the OnKey event procedure and test for the <Enter> key.

 

[hkaing79]

For the enter button, click on properties and find "Enter Key Behavior" and select "New Line in Field".

Unfortunately, I haven't figured out how to overcome the tab problem. The best solution I could come up with was using the KeyPress event.

If KeyAscii=9 Then
Field1=Field1 & vbTab
End If

Unfortunately, this highlights your field instead of continuing as it should be.

 

[needadvice]

To hkaing79,
I think that will work fine for the enter key. I was not aware of this property setting. As for the tab key, I'll just disable it.
Thanks Again, this should solve the problem