Link to home
Start Free TrialLog in
Avatar of LISA GEORGE
LISA GEORGE

asked on

Controls position got locked

Hi, I have an existing continuous subform with some controls.
Now i added extra 2 control buttons in the form. I arranged controls like i need and modified in layout view as well(i want my new controls to be in last but 1 position, they are like the way i want in layout and design view)
but when i switch to form view, 2 new controls which i added now got locked in same position where they are in layout view(new controls are now in middle of row like overlapping on some other existing controls)
how do i auto sync them with existing controls so that they appear same way as my layout view
what option do i need to select? as these are new controls do  i need to do some settings
please help me as i am pretty new to access
regards,
Lisa
Avatar of PatHartman
PatHartman
Flag of United States of America image

If you are using a form in datasheet view, this can sometimes be a challenge.  Once you rearrange the controls on the form in design view, press the tab order button to reset the tab order.  In theory, this will fix the problem.

If it doesn't, create a new query that selects the columns you want IN THE ORDER YOU WANT THEM TO APPEAR.  Remove the existing RowSource for the subform and replace it with this new query.
A screenshot of your form in design view, as well as form view would probably help explain what is going on. Based on your description I *think* the 2 added controls are in a different layout grid (Not the same as layout view) than the first controls.

If you select the new controls in design view, and under the Arrange tab in the ribbon, click Remove Layout, you should then be able to drag-n-drop the controls into their position in the existing layout grid.
Avatar of LISA GEORGE
LISA GEORGE

ASKER

@anders definitely i can send you screenshot
i already tried to remove layout for the new controls but when i selected them under arrange tab remove layout is grayed
and as this form was done by someone else i am not sure which layout they have used
is there any way i can do this
You can upload the screenshots here, by first saving them as local files, then uploading them via the "Insert Image" button of the post.
@anders, as i dont have access to application now , i can't send screenshots
i can do that after few hours
Is there any difference with your forms in Normal view vs Layout view?  I don't use Layout view so I don't know if it screws things up or not.
@mark yes in layout view we can adjust controls and preivew them
but as i didn't find solution how they got locked so i recreated form again
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.