Properties for a single memo field, searchable, scrollable and not selected by default

[Fjordur]

Hi,
I'm doing a "Tips and Tricks" help window, based on a single table with an
autonumber and a memo field. The form has a single memo field, no control.
The form is a snaphot.
I don't want the field to be selected whenever a new record is opened
because then it's reverse video.
I want it to display its vertical scrollbar if th etext is too long to fit
the field height.
I want the text field to be enabled (so that the users can search it).

I found that setting enabled to no, tabstop to no and locked to yes doesnt
display the scoll bar and doesnt allow search.
Any suggestion for the proper combination of properties?

 

[Dirk Goldgar]

Hi,
I'm doing a "Tips and Tricks" help window, based on a single table
with an autonumber and a memo field. The form has a single memo
field, no control. The form is a snaphot.
I don't want the field to be selected whenever a new record is opened
because then it's reverse video.
I want it to display its vertical scrollbar if th etext is too long
to fit the field height.
I want the text field to be enabled (so that the users can search it).

I found that setting enabled to no, tabstop to no and locked to yes
doesnt display the scoll bar and doesnt allow search.
Any suggestion for the proper combination of properties?

Set Enabled to No, Locked to Yes (though that's probably not necessary
if the recordsource is a read-only snapshot), make sure the control is
first in the tab order, and have an event procedure for the control's
Enter event like this:

'----- start of example code -----
Private Sub txtYourMemoField_Enter()

Me!txtYourMemoField.SelLength = 0

End Sub
'----- end of example code -----