Create a label with scroll bars?

Andy

When a textbox displays #Name, Access can't tell what field you are using as
a control source.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Andy" wrote in message
...
Thanks Doug, I have done this, but when I come out of design view and go
back
to Form view, the text box is displaying #Name? instead of my text. I am
simply copying the text from my label and pasting it into the textbox

"Douglas J. Steele" wrote:

Use a text box, but set its Locked property to True so that they can't
change the text that's displayed.

Text boxes can have scroll bars: labels can't.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Andy" wrote in message
...
Quite possibly I am using the wrong tool and it should not be a label.
I
have
a form and within the form I need to list a lot of text so that the
user
can
reference it within the relative tab on the form.

I see two options of use a label and let the form have scroll bars
(trying
to avoid), or use something that I can put within a fixed form that
itself
has scroll bars.

Almost like a terms and conditions textbox when installing software
(infact
like the box I'm typing in now!).

"Jeff Boyce" wrote:

Andy

Let's make sure we're talking about the same thing.

In Access, a label is used to provide a brief title to help the user
know
what goes in the control associated with it. Requiring the user to
read
an
extensive label that needed a scroll bar to include it all would be
unusual.

You've described a "how" (label with scroll bar). Now, how about
describing
the "what" and "why". If you had your label with scroll bar, what
would
you/your users be able to do? I'm asking, not out of curiosity, but
because
having a better sense of the underlying business need will help the
folks
here in the newsgroup look at possible other approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Andy" wrote in message
...
Is this possible? I have loads of text in a label on a form, but
would
prefer
to make the label smaller and therefore need a vertical scroll bar,
but
there
is no option for this.

Do I need to insert something else and copy the text in to get a
scroll
bar?

Ta