From: Billiam on
Is it possible to produce vertical page tabs in Access 2007? I would like my
form to appear like a binder with index dividers on the right hand side.

Thanks,
Billiam
From: Brendan Reynolds on
"Billiam" <Billiam(a)discussions.microsoft.com> wrote in message
news:BAD2CBC5-15DD-4C69-8BCD-14E184050F48(a)microsoft.com...
> Is it possible to produce vertical page tabs in Access 2007? I would like
> my
> form to appear like a binder with index dividers on the right hand side.
>
> Thanks,
> Billiam


There's no built-in option to change the orientation of the tab control, but
you could set the Style property of the tab control to None (so that it
doesn't display any visible tabs) then use a column of command buttons or
labels down the right side of the form to set the Value property of the tab
control to display the relevant page ...

Private Sub cmdPageOne_Click()
Me.tabTest.Value = 0
End Sub

Private Sub cmdPageTwo_Click()
Me.tabTest.Value = 1
End Sub

Private Sub cmdPageThree_Click()
Me.tabTest.Value = 2
End Sub

Note that the pages collection is zero-based, so set the Value property to 0
to display the first page, 1 to display the second page, etc.

--
Brendan Reynolds

From: Billiam on
Hi Brendan,

Sorry, I did see another post by you which I had missed before on this
topic. I am going to try this out today. I have never done anything like this
before as I am new to Access. I promise to rate the response and add anything
that might help a newbie like me! Thanks again for your help.
Billiam
"Brendan Reynolds" wrote:

> "Billiam" <Billiam(a)discussions.microsoft.com> wrote in message
> news:BAD2CBC5-15DD-4C69-8BCD-14E184050F48(a)microsoft.com...
> > Is it possible to produce vertical page tabs in Access 2007? I would like
> > my
> > form to appear like a binder with index dividers on the right hand side.
> >
> > Thanks,
> > Billiam
>
>
> There's no built-in option to change the orientation of the tab control, but
> you could set the Style property of the tab control to None (so that it
> doesn't display any visible tabs) then use a column of command buttons or
> labels down the right side of the form to set the Value property of the tab
> control to display the relevant page ...
>
> Private Sub cmdPageOne_Click()
> Me.tabTest.Value = 0
> End Sub
>
> Private Sub cmdPageTwo_Click()
> Me.tabTest.Value = 1
> End Sub
>
> Private Sub cmdPageThree_Click()
> Me.tabTest.Value = 2
> End Sub
>
> Note that the pages collection is zero-based, so set the Value property to 0
> to display the first page, 1 to display the second page, etc.
>
> --
> Brendan Reynolds
>