Order of columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that has five text boxes: Product, Price, Quantity,
Sub-Total, and Total. In design view, they are in that order from top to
bottom. When I swith to form view, however, they are horizontal and are in
the following order: Price, Quantity, Sub-Total, Total, and Product. I like
how they are horizontal (database style), but how do I move the product
column to where it should be (all the way to the left in form view)?
 
I have a subform that has five text boxes: Product, Price, Quantity,
Sub-Total, and Total. In design view, they are in that order from top to
bottom. When I swith to form view, however, they are horizontal and are in
the following order: Price, Quantity, Sub-Total, Total, and Product. I like
how they are horizontal (database style), but how do I move the product
column to where it should be (all the way to the left in form view)?
Click to expand...

While the form is displayed in Datasheet View, the user can select the
column by clicking on the column header then left-click and drag it
where you want it.

You can also set the column order using code.
In the Form's Load event:
Me![Product].ColumnOrder = 1
Me![Price].ColumnOrder = 2
etc.
 
I assume that the sub form is in datasheet view, then open the sub form
seperatly, without the main form and change the order of the field by click
and drag to the right position, when you close the form if access ask you if
you want to save the layout, click yes.
The next time you'll open the main form the order of the fields in the sub
form will be in the right order
 
Harvey

What is the form based on, a query or a table? What order are the fields in
that source?

If you open the form and "they are horizontal", I suspect you have selected
a Datasheet view. Have you looked into using the Continuous Form view
(these are choice on the DefaultView Property of the form)?
 
Problem solved! None of those suggestions worked, but thanks a lot for
taking the time to answer. I changed the tab order, and all of a sudden, they
lined up the way I wanted. :) Thanks again!
 
Back
Top