Scroll bars in text box

[David Worledge]

I want to add a vertical scroll bar to some text boxes on
a form. Setting the scroll bars property in the text box
property list to 'vertical' does not work. I have other
forms in the same database which have text boxes with
vertical scroll bars working just fine, but there is no
difference that I can see in the whole set of properties
for either the text box controls or the forms. The irony
is that I discovered a few months ago how to fix the
problem, but have now forgotten.

 

[chriske911]

maybe the data behind those textboxes is a memo field ?
that way you get a scrollbar automatically when inserting the field in your
forms

grtz

 

[David Worledge]

No, it is enabled and not locked. I can scroll through
the items (which are in a list which is longer than the
text box height) by holding down the left mouse button and
placing the cursor near the bottom of the box. That works
but it's hokey. I know there is a simple switch somewhere
to fix it because I had the problem on another form about
a year ago and eventually solved it.

 

[Rick Brandt]

Hi Ken,

I saw your post and thought you may know how to solve my
problem. I'm fairly new to access and would like to try
and set up my first database. What I would like to create
is a simple database that allows me and others to keep
track of various work related support issues. My problem
lies in when a user would like to type in a message that
would exceed the 255 characters that a text box seems to
allow. For instance, let's say that I wanted to store
this message here in a particular field? Is this possible?

It's not the TextBox that has the 255 character limitation, it's the field in the
table that you have defined as Text. Change it to a Memo DataType and it will hold
around 64K characters.