
May 8th, 2008, 08:12 AM
|
|
|
Quote: | Originally Posted by Venerable Complete noob at Access here, so I'll try and explain in a understandable way. I've used the template called "Inventory Controll", but changed various things to make it fit my needs better.
I have a Form with a scrollable part in the section called Details. Every time I start to write in a Lable, a new one appear. So lets say I have 3 different Lables. When I exit the form, and come back, they've all changed location. But I want the different Lables to keep in the same order as I write them in.
Does anyone know how I can stop them from changing order? |
Labels are just that, labels, and cannot be sorted. They are the objects in your form where you use to title your form,label your fields, etc. As such, I am assuming that your are talking about text fields in a continuous form. To control the sort order of the text field, go to the under laying query for the form. If the form is not bound to a query, then you need to bound it to a query instead of directly to a table. In the query in which the form is bound, in the row that is labeled "sort" for the field in which you want the sort order to be set, set it to either "Descending", or "Ascending". When you open the form the next time, the fields will sort in the order you have set in the query.
|