DoCmd.OpenForm with Memo fields

[apestaart]

Using DoCmd.OpenForm "FormName",acNormal,,,acFormEdit gives me a result that I don't want.
It opens the form and goes to the first field in my case a memo field. The complete text is highlighted and the cursor is at the beginning of the text.
What I want is to set the cursor at the end of the memoblock, so that I can give in additional data. (With no Highlighting)
Changing acFormEdit to acFormAdd works, but than I can't see the exsisting data in the field.

Who can help me?
Regards
apestaart

 

[Eupher]

Hi, apestaart,

Have a look at the SetFocus, SelStart, and SelLength methods.

Ken S.

 

[apestaart]

Hallo Eupher,
That I did already, but I can't use that in my oppinion.
How can I set the cursor to the last caracter of the memo field plus 1? And let the highlighting dissapire?
Apestaart

 

[PHV]

In the Enter event procedure of the TextBox:
Me![name of textbox].SelStart = 1 + Len(Me![name of textbox].Text)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AvGuy]

Under Tools >> Options you can set the position of the cursor in a text box.

 

[apestaart]

Thanks for your help! It works in the way PH discriped and
ment by Eupher.
Regards Apestaart