473,656 Members | 2,777 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can a control on a Datasheet have a scrollbar?

I haven't been able to find this answer in previous posts;

I have a form, with a subform that is displayed in datasheet view, and
one field "Item Description" could be from very few to many characters.
I would love to just show 2 inches, and have a scroll bar for viewing
the rest of the info.

I have my form property set to Default View: DataSheet, views:
Datasheet. My form is set to Scroll Bars: Vertical, but when I open it
I get both scroll bars, also.

I have my control set to visible, Scroll Bars: Vertical. I do not get
a scroll bar in the control, so I'm wondering if you can't have a
scroll bar in a datasheet, and maybe I should use a continuous form?

(I'll take opinions on using datasheet vs continuous forms, too. Being
new to forms, I don't know which to use)

Many thanks. I know this is simple; I'm sure I'll have a more
challenging question coming up!
sara

Nov 13 '05 #1
5 3944
"sara" <sa*******@yaho o.com> wrote in message
news:11******** *************@g 47g2000cwa.goog legroups.com...
I haven't been able to find this answer in previous posts;

I have a form, with a subform that is displayed in datasheet view, and
one field "Item Description" could be from very few to many characters.
I would love to just show 2 inches, and have a scroll bar for viewing
the rest of the info.

I have my form property set to Default View: DataSheet, views:
Datasheet. My form is set to Scroll Bars: Vertical, but when I open it
I get both scroll bars, also.

I have my control set to visible, Scroll Bars: Vertical. I do not get
a scroll bar in the control, so I'm wondering if you can't have a
scroll bar in a datasheet, and maybe I should use a continuous form?

(I'll take opinions on using datasheet vs continuous forms, too. Being
new to forms, I don't know which to use)

Many thanks. I know this is simple; I'm sure I'll have a more
challenging question coming up!
sara

Have you considered any other alternatives? One could be a fixed textbox
with scroll bars on the main form where you display a fuller version of the
text in the datasheet view. Each time you move to a different record on the
subform, the text is reloaded. Another possibility might be to double-click
the textbox to display a popup form showing the complete text, or as much as
you can, plus scrollbars.


Nov 13 '05 #2
Thanks. I will try the pop up - but I'm very inexperienced so it may
take a bit. Do you know the answer to my original question? CAN the
textbox have a scrollbar on a datasheet?

sara

Nov 13 '05 #3
"sara" <sa*******@yaho o.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .
Thanks. I will try the pop up - but I'm very inexperienced so it may
take a bit. Do you know the answer to my original question? CAN the
textbox have a scrollbar on a datasheet?

No, but you could try faking a datasheet view using textboxes on a form
view.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #4
"sara" <sa*******@yaho o.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .
Thanks. I will try the pop up - but I'm very inexperienced so it may
take a bit. Do you know the answer to my original question? CAN the
textbox have a scrollbar on a datasheet?

sara


No, I don't believe there is any way to do this. You could try making the
form show as continous forms, which is a bit similar to a datasheet view -
then you can have scrollbars on your textbox.
If you need help with the popup bit, just let us know.
Nov 13 '05 #5
Thanks - Off I go! Appreciate the offer for help. I want to try it on
my own with Access Help and prior posts first.

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4138
by: Joshua Ammann | last post by:
Hi, (Using Access 2000) I have two tables, similar to Customers and Orders. (Not an exact parallel, but works for this example.) On a form showing customer data, there is a tab control. One of the tabs has a subform showing order data (in datasheet view). On the same tab there is an unbound textbox (next to the datasheet). I placed a
1
2043
by: Helmut Blass | last post by:
hi folks, I have embedded a datasheet as a subform and I want that every time the datasheet is updated, the focus be set on the last record and be visible for the user. that is like simulating the users activation of the scrollbar, so that the last record is visible. got any idea? thanx for your help, Helmut
1
6828
by: VINAY | last post by:
Dear All, The subject line could be bit confusing. So let me explain in details, please have patience. I have developed an ActiveX Control(Combo Box Control) in VB6 for a touch screen application since the user had problems working with the small Combo Box Button and Scroll Box Scroll Button that appears in the Combo Box Control Shipped with VB. While going through questions in this group i learnt that one can change the size of the...
4
16435
by: Paul T. RONG | last post by:
Dear all, Can one control the subform scrollbar through vba? For example, I would like to make two command buttons on the main form to control the subform scrollbar. Click 1st button the subform vertical scrollbar goes down to the end, click 2nd button goes up to the top position. Thank you for your help,
0
1224
by: Anupam Mukherjee | last post by:
Hi, I have a Vertical ScrollBar inside a form. How do I get or set the height of the paddle inside the ScrollBar control? Note that it is a separate ScrollBar control nad cannot lnow by itself when I want its paddle to be large and when it should be small. Regards, Anupam
0
1658
by: Lundy | last post by:
greetings, The listbox control on my aspx page has a vertical scrollbar. But some of the text extends beyond the right limit of the listbox. I don't see a horizontal scrollbar, and I don't see any scrollbar properties in the property sheet in vs2003. Would this be a styles item? If so, how to invoke. If not, is it possible to invoke a horizontal scrollbar? how to do that?
2
2117
by: MrNobody | last post by:
IF I am making a custom user control which draws stuff that might exceed its boundaries, can I get the user control to handle the scrolling for me? The AutoScroll property doesn't seem to be doing it. Do I have to set some special Size so it knows it's supposed to scroll? Currently by default behavior it is just clipping my content and not putting any scrollbar. and if I can somehow get the user control to add the scrollbar how can I...
0
2337
by: evan | last post by:
Hi, Is anyone able to give me an example on how to scroll the contents of a ListBox without forcing the user to click on the scroll up/down internal buttons? ============================== I am wanting to draw my own non-client area (including the scrollbar). I have had the following ideas but each idea has failed:
16
12598
by: ulam | last post by:
I have a form shown in datasheet view, and I have some actions that require that form to be requeried with a delete operation, however number of rows in the datasheet view remains constant with a delete operation in this specific case. I am trying to return the user back to the same row that he just selected the action on, and also at the same position on the screen - i.e. the same row and the same position of the scrollbar. An example: ...
0
8717
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8498
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8600
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7311
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6162
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5629
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1600
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.