Memo field problem

  • Thread starter Thread starter KirstieA
  • Start date Start date
K

KirstieA

All,

I have a pop-up form which shows only one field. The field is a memo field,
and can contain a lot of information.

My problem is that when the form opens, all the text in the field is
highlighted, as if you have selected all. This means unless someone clicks
to the end of the text already there before they start typing, all the text
already there disappears and is lost (unless my user is smart enough to ctrl
z immediately - which they may not be).

How can i fix this problem?!

Any suggestions much appreciated,

Kirstie
 
KirstieA said:
All,

I have a pop-up form which shows only one field. The field is a memo
field, and can contain a lot of information.

My problem is that when the form opens, all the text in the field is
highlighted, as if you have selected all. This means unless someone
clicks to the end of the text already there before they start typing,
all the text already there disappears and is lost (unless my user is
smart enough to ctrl z immediately - which they may not be).

How can i fix this problem?!

Any suggestions much appreciated,

Kirstie
Click to expand...

In the open event of the form...

Me.TextBoxName.SetFocus
Me.TextBoxName.SelStart = Len(Nz(Me.TextBoxName, ""))
Me.TextBoxName.SelLength = 0
 
Take a look at Tools --> Options --> Keyboard --> "Behavior entering field"
and make sure that "Select Entire Field" is not checked.
 
Back
Top