 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Create a label with scroll bars?
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 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 > Is this possible? I have loads of text in a label on a form, but would > prefer [quoted text clipped - 6 lines] > > Ta 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!). > Andy > [quoted text clipped - 25 lines] > > > > Ta 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 > Quite possibly I am using the wrong tool and it should not be a label. I > have [quoted text clipped - 43 lines] >> > >> > Ta 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. > Andy > [quoted text clipped - 57 lines] > >> > > >> > Ta > 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 [quoted text clipped - 61 lines] >>>> > >>>> > Ta 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.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail 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 > 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 [quoted text clipped - 73 lines] >> >> > >> >> > Ta 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. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Quite possibly I am using the wrong tool and it should not be a label. I > have [quoted text clipped - 43 lines] >> > >> > Ta 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 > Use a text box, but set its Locked property to True so that they can't > change the text that's displayed. [quoted text clipped - 48 lines] > >> > > >> > Ta 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) SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Thanks Doug, I have done this, but when I come out of design view and go > back [quoted text clipped - 64 lines] >> >> > >> >> > Ta 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 > Thanks Doug, I have done this, but when I come out of design view and go > back [quoted text clipped - 64 lines] >> >> > >> >> > Ta |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.