memo box

  • Thread starter Thread starter malcolmmabe
  • Start date Start date
M

malcolmmabe

i have set up a memo box on a form that is locked until
the user double clicks it. however, when it's lock the
user can only see the beginning of the memo box, even
though the memo box contains a lot of data that can only
be seen by scrolling. how can it be set that the last of
the data is visible?
 
Are you saying that with it locked, you can scroll to the bottom to see what
is there but that you would prefer it to start with the cursor at the
bottom, showing the last entries and scrolling to the top if you wanted to
see the first entries? If so, try the SelStart property of the textbox. The
textbox has to have the focus in order to do this.

Me.txtMyTextbox.SelStart = Len(Me.txtMyTextbox.Text)
 
i have set up a memo box on a form that is locked until
the user double clicks it. however, when it's lock the
user can only see the beginning of the memo box, even
though the memo box contains a lot of data that can only
be seen by scrolling. how can it be set that the last of
the data is visible?
Click to expand...


I've been trying to figure out what your scenario is here,
but something(?) Wayne said triggered a thought.

I think you're asking how to show the "bottom" of the memo
whether the memo text box has the focus or not. Sort of
like you add notes to it and only need to see the last few,
but you do want to see those last few when you're moving
from record to record, without clicking in the memo text
box.

If that's what you want, then it will get tricky, since the
scroll only exists when the text box has the focus. Here's
a crude idea I came up with, add a new text box the same
size as the memo text box and position it directly on top of
the memo text box. Set the new text box's control source
expression to something like:

=Right([memofield], 200)

This text box will not be editable since its value is from
an expression. Now, add code to this text box's double
click event procedure to change the focus to the memo text
box and set SelStart so it displays the end of the memo
field.

With Me.memotextbox
.SetFocus
.SelStart = Len(.Value)
End With

The subtle trick here is that the memo text box will not be
seen until you double click the new text box, but as soon as
the memo text box receives the focus it will temporarily be
displayed over the new text box.
 
Back
Top