[AccessD] DoCmd.GotoControl shifts form?

[Bill Benson]

Ryan check you haven’t got an unusual resolution percent in display
settings. I have seen things get a bit mucky with 125%, I try to keep to
100%.

On Fri, Mar 24, 2023 at 6:22 PM Ryan W <wrwehler at gmail.com> wrote:

> Yeah I wish I could show more but I’d need to blur out some sensitive data
> and my screen recorder doesn’t have a way to do that.
>
> The add button is a 4 step process.
>
> 1 screen.activeform.setfocus
> 2 docmd.gotocontrol “child1”
> 3 docmd.gotocontrol “topcontrol”
> 4 docmd.gotorecord ,,AddNew
>
> Step 2 is where the form sort of jumps around, depending on window size
> and control sizes.  I don’t think it’s usual to set the subform control
> itself in focus but I can’t jump to the top control without jumping to its
> parent control first. Which leads to:
>
> For some reason gotorecord doesn’t add a new record if I try and just set
> focus on the top control ala:
>
>  forms!lrc!child1!topcontrol.setfocus
>
>
> 🤷
>
> Most of the forms in the DB use the ribbon controls to add/delete/copy
> records in the same manner so changes to this code aren’t really in the
> cards
>
> Sent from my iPhone
>
> > On Mar 24, 2023, at 4:33 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
> wrote:
> >
> > Without seeing at least the whole "Lab Review Checklist" form and
> preferable the whole
> > Access application window it's pretty hard to tell what is happening.
> >
> > Also what is actually happening with the Add button. It is clearly more
> than just a
> > Docmd.Goto.
> >
> > Link to a stripped down sample database showing it would be useful.
> >
> >
> >> On 24 Mar 2023 at 12:08, Ryan W wrote:
> >>
> >> There's some sort of correlation between anchoring and using focusing
> >> on a child subform (and then a control on that subform) to use
> >> docmd.gotorecord,,acnewrec (in the case of add).
> >>
> >> It also happens with Forms!FormName!SubFormControlName.setfocus....
> >>
> >> If I tinker enough with the control sizes that anchor and stretch down
> >> I can get it to stop dancing on me...
> >>
> >>> On Thu, Mar 23, 2023 at 2:42PM Ryan W <wrwehler at gmail.com> wrote:
> >>>
> >>> Has anyone had experience with DoCmd.GotoControl shifting the form
> >>> around a little if the form isn't "Wide enough"?  I have a popup
> >>> that if it's just narrow enough to fit ALL the data, but
> >>> docmd.gotocontrol will shift everything to the left a little bit
> >>> (seen in this video)
> >>>
> >>> https://www.screencast.com/t/xvBhK3oCr
> >>>
> >>> If the form is slightly wider, this doesn't happen but makes the
> >>> form look weird with empty space on the right (this is a popup form
> >>> with a sizable edge I'm tinkering with for people to move it to a
> >>> second monitor (which is vertical, thus more narrow).
> >>>
> >>> If you watch, my index on the left (blue rectangle) gets cut in half
> >>> as it moves off view and so far the only fix is to close the form
> >>> and re-open it.
> >>>
> >>> The GotoControl is part of the ADD/DELETE/COPY buttons on the ribbon
> >>> and have been working well on maximized forms (can't repo it
> >>> there)....
> >>>
> >>>
> >>>
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> https://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>