Fritz Paul
asked on
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
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.
ASKER
You've got me. What is the "QAT"? Please.
ASKER
Oh OK, I found it on Google.
No it does not work.
No it does not work.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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