An Acccess form doesn't know a memo field from Adam! A textbox is a textbox is a textbox, regardless of the data type it holds. The default for
Entry Key Behavior is
Default, which is to say, whatever behavior is set under
Tools - Options - Keyboard. Those choices are
Don't Move,
Next Field or
Next Record.
Move to new line can only be set as you've indicated, and the scrollbar(s) default to
None, so this
will have to be set if desired. If memory serves, they only appear when the textbox has focus.
If by "
Is there a way to easily add new text to this memo field when I reopen the form" you mean can you automatically move to the end of the data already in the memo field, use this code, replacing
YourMemoField with the actual name of your textbox.
- Private Sub YourMemoField_GotFocus()
-
-
If Len(YourMemoField) > 32767 Then
-
YourMemoField.SelStart = 32767
-
Else
-
YourMemoField.SelStart = Len(YourMemoField)
-
End If
-
-
End Sub
Welcome to TheScripts, alany!
Linq
;0)>