Avatar of Fritz Paul
Fritz Paul
Flag for South Africa 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: query design
Form  design: form designDatasheet view: Datasheet viewThanks
Microsoft Access

Avatar of undefined
Last Comment
Fritz Paul

8/22/2022 - Mon
Dale Fye

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.
Fritz Paul

ASKER
You've got me. What is the "QAT"? Please.
Fritz Paul

ASKER
Oh OK, I found it on Google.
No it does not work.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SOLUTION
Gustav Brock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Dale Fye

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Fritz Paul

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.
PatHartman

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.
Fritz Paul

ASKER
Thanks guys.
It is solved, but this is such an unfriendly process, just to get your fields in required sequence!
Regards
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.