|
From: Billiam on 17 Jun 2008 09:35 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 18 Jun 2008 05:41 "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 18 Jun 2008 08:07 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 >
|
Pages: 1 Prev: Database creating Next: Proper Table Design and Combo Box Help |