TextBox problem

[AndyBannister]

I have come across an annoying but niggling problem. I have a large text box on a form, linked to a memo field. I want the textbox to show its scrollbars when the form is first opened, however the only way I can see to do this is to give the textbox the focus.

So far, no problem ...

.. but if the text box has the focus, the form opens with all the text in the box highlighted. Of course, I can turn off the highlighting options in TOOLS->OPTIONS->"Behaviour Entering Field", but I only want this behaviour on one form, not throughout the whole database.

Is there a simple way to manipulate Access options in VB? Or am I missing something really obvious --- such as a way of turning on textbox scrollbars permanently, not simply when the control has the focus.

Many thanks for any help.

Andy Bannister

 

[chrismcbride]

Quick and dirty , but this works

Me.long_desc.SetFocus
Me.long_desc.SelStart = 0

HTH
Chris

 

[AndyBannister]

Thanks

Quick and dirty it may be, but it worked. Many thanks.