The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.
Set field sequence of a form in sheetview
I added a field to a table which is part of an existing query and then included the field in the query design in the position that I want it to display.
When I view the query, the field is in the required position.
I also inserted a field in the corresponding form in the required position.
When I view the form in sheetview, the new field is right at the right hand end of the fields.
Is there a way of determining the field sequence without using VBA?
This is what I did. The field in question is [Confirm].
Query design:
Form design:
Datasheet view: 
Thanks
When I view the query, the field is in the required position.
I also inserted a field in the corresponding form in the required position.
When I view the form in sheetview, the new field is right at the right hand end of the fields.
Is there a way of determining the field sequence without using VBA?
This is what I did. The field in question is [Confirm].
Query design:
Form design:
Datasheet view: Thanks
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
LVL 54
Theoretically, in datasheet view, you should be able to drag the column to where you want it, and then click the save button in the QAT. That should save the position.
You do that by setting (in code only) the property ColumnOrder of the textbox/combobox.
First control has no. 1, and if you set a control to, say, 4, those with values of 4 and higher will be shifted up by 1.
/gustav
First control has no. 1, and if you set a control to, say, 4, those with values of 4 and higher will be shifted up by 1.
/gustav
Then use the technique that Gustav mentions.
Use the Load event of the form, and code similar to the following, I generally set them in reverse order, right to left, setting the columnorder to zero for each control.
I've also got an EE article on allowing users to customize their datasheet column orders and widths, and then save those settings for the next time they load a datasheet.
Use the Load event of the form, and code similar to the following, I generally set them in reverse order, right to left, setting the columnorder to zero for each control.
Private Sub Form_Load
me.controls("txtFarRight").columnOrder = 0
me.controls("nextCol").columnorder = 0
...
me.controls("farLeftControl").columnorder = 0
End Sub
I've also got an EE article on allowing users to customize their datasheet column orders and widths, and then save those settings for the next time they load a datasheet.
MS has completely hosed the way datasheets work in newer versions of Access. It is virtually impossible to control position and width of columns. Someone on the team should look at how this worked in A2003 and go back to that feature set.
When you add a new control to a form it is always a good idea to press the TabOrder icon on the Design tab and then either press the Auto Order button or manually rearrange the sequence. You can also do this by typing a number into the tab index property of an individual control. I usually end up doing one or all of these depending on how many controls I am repositioning and how complex the form is.
Also, the picture you displayed does not show the form design of a DS form. It looks like a continuous form. When you display this form in DS view, you will have trouble changing the column names since there are no labels attached to the textboxes and that is what Access is going to use to create the column headings. If you use a Continuous format form and display it as DS, Access uses the column names from the query as the column headers. It was years before I worked this out. Nothing in the documentation mentions this. I used to avoid using DS subforms because I never want to use my internal column names as the column headers.
Notice that the column headers match the control labels rather than the column names.
When you add a new control to a form it is always a good idea to press the TabOrder icon on the Design tab and then either press the Auto Order button or manually rearrange the sequence. You can also do this by typing a number into the tab index property of an individual control. I usually end up doing one or all of these depending on how many controls I am repositioning and how complex the form is.
Also, the picture you displayed does not show the form design of a DS form. It looks like a continuous form. When you display this form in DS view, you will have trouble changing the column names since there are no labels attached to the textboxes and that is what Access is going to use to create the column headings. If you use a Continuous format form and display it as DS, Access uses the column names from the query as the column headers. It was years before I worked this out. Nothing in the documentation mentions this. I used to avoid using DS subforms because I never want to use my internal column names as the column headers.
Notice that the column headers match the control labels rather than the column names.
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
Dear PatHartman,
Thanks for your reply. It looks like what I was looking for and I will test it out and give feedback.
I know the VBA method, but specifically asked "Is there a way of determining the field sequence without using VBA?".
Thanks.
Thanks for your reply. It looks like what I was looking for and I will test it out and give feedback.
I know the VBA method, but specifically asked "Is there a way of determining the field sequence without using VBA?".
Thanks.
The problem is as I said in my opening statement, MS has completely hosed this process. USUALLY, setting the tab order will get the columns in the desired order but not always. SOMETIMES, if the tab order won't work, you can open the form in Layout view and drag the columns around. It is getting your edits to stick that is so elusive.
Thanks guys.
It is solved, but this is such an unfriendly process, just to get your fields in required sequence!
Regards
It is solved, but this is such an unfriendly process, just to get your fields in required sequence!
Regards
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.