MS Access 2000 Toolbox Horz Scroll bar?

[muckmail]

Does MS Access textbox properties have a horzontial scroll bar?
I was looking at the properties of a textbox and I can only
find a property that adds a vertical scrollbar. Not a
horz scrollbar. Is there a wordwarp feature that can turned
off in access. There wordwrap property in MS excel but I can't
find it in Access. Need a horzontial scrollbar in MS Access 2000
toolbox. Is there any way to get one in a MS access
2000 textbox?

[zeneri]

I'm not sure, if there is any textbox control with horizontal scrollbar. But as a workaround you might create a subform containing a textbox wide enough to hold your text without wrapping around. Provide this subform with horizontal/vertical scrollbar (turn off everything else like navigation controls etc.) and insert this subform in your original form. Here you can size it as you like.

Hope this helps.

[RobDog888]

Yes, there is a scrollbar, but you need to add it to your Toolbox first.

Click View > Toolbox from the main menu when viewing your form
in design mode.



Then click the More controls button on the toolbox.

[RobDog888]

Then scroll through the control references until you find the
"Microsoft Forms 2.0 Scroll bar". Then click it. Then drag and draw
the scroll bar control on your form. And presto!



You will still need to add code to make the textbox scroll, but you
get the idea now. Use SelStart and SelLen etc. to position the
cursor in the textbox. This will make the textbox scroll either left
or right depending on the value you read from the scroll bar.

Edit: Since its a reference to MS Forms 2.0 you dont need
any other files to distribute, other that the client needing Access.


VB/Outlook Guru!