Main Form/Subform Scrollbar Issues

[Jenaccess]

Hi,

I'm having the following problem with my form (Access 2010):

I need the flexibility of datasheet view, but also need to be able to put command buttons on my form. I went with the solution of using a main form for the command buttons and the datasheet as subform. This isn't too bad of a solution so far, but I'm running into trouble with the scrollbars.

Having both the main and subform scrollbars is messy and confusing. But if I make the subform ones invisible, I can only scroll horizontally to a certain point, and if I make the main ones invisible I can't scroll at all. Would anyone know of a workaround to this problem?

I'd appreciate any suggestions you can give me. Thank you for your time!

 

[CJ_London]

Try setting the main form scrollbars to no and the subform scrollbars to yes.

 

[Jenaccess]

I gave that a try and now I'm unable to scroll at all. Unless I'm missing something?

 

[gemma-the-husky]

CJ's solution should work. Scroll bars only activate if they need to be there though, if you can see everything, you wont have the scrollbars.

maybe datasheets do not have scrollbars? I tend to use continuous forms.

 

[Jenaccess]

I think I will go for the continuous form. I was trying to make a query tool where the user could select the columns they wanted. There are about 50 total, and the datasheet is the only view flexible enough to display them all at once. But the user choosing all the fields at any given time is so unlikely that I don't think it would be worth it to spend the time creating the infrastructure that would allow them to do so. I think I'll limit the fields I'll allow for in any given query. Thank you both for your help.

 

[CJ_London]

@Gemma

maybe datasheets do not have scrollbars?

They do! same as continuous. Jenaccess - unless Gemma's point is valid for you (i.e. there is nothing to scroll, suggest you post a screenshot of your form

 

[Simon_MT]

To get around your problem of 50 fields, I agree put the main ones on a subForm. You could try puttting Fields on a pop-up dialogue like this, this is additional information relating to the Stock Record.

Simon