Create a label with scroll bars?

[Guest]

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

 

[Jeff Boyce]

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

 

[Guest]

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]

Andy

If you use a textbox control to hold the contents of an underlying table
field (whether text or memo data type), you should have "automatic"
scrollbars if there's more text than fits within the textbox control.

I assume, since we're in a "forms" newsgroup, that you are working in a
form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

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.

 

[Guest]

Yes this is within a form. The text is not in a table at all (otherwise I
would have used a textbox). It is just ad-hoc text that I need to insert into
a form.

 

[Guest]

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]

Not quite sure what you mean by copying the text from the label and pasting
it into the textbox.

Set the text box's ControlSource to something like:

="This is the data that will appear in the text box."

(including the equal sign)

 

[fredg]

Yes this is within a form. The text is not in a table at all (otherwise I
would have used a textbox). It is just ad-hoc text that I need to insert into
a form.

You're misunderstanding the suggestions given.
Use an unbound text control (not bound to any field in a table).
Set it's control source to:
="This is all of the text."
Set it's scroll bar property to vertical.

It will appear on the form exactly as though it were a label.
When the user clicks on it, a scroll bar will appear.

 

[Jeff Boyce]

Andy

You do understand that if your control is not bound to an underlying field,
its contents will not be stored? Given that, why do you want a place for
users to type something they won't be able to save?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

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