Stop Form Jumping on Startup

[mapline]

Hi

Perhaps I'm a perfectionist but an application that I have does not display the ribbon bar, status bar, navigation etc. just the form on startup form.

It seems that the deletion of the bars does not take effect until after the form loads so it jumps ( AND I DON'T THINK THAT LOOKS RIGHT!)

Any thoughts on how to effect the actions before the form loads?

Thanks



Michael

Have example accdb attached

[ajetrumpet]

you cant stop it from jumping, and the reason is because youre manipulating the ribbon AS youre opening the form. try opening the form AFTER you run that code, maybe both commands in the same procedure called by an auto exec macro??

that's one option, which is better.

but also know that you will not be able to avoid the screen looking like it's jumping with the code you're using because it has to adjust itself when the ribbon is hidden via a command. it's a basic necessity of the computer screen/resolution and its parameters.

[mapline]

Hi Adam
same thoughts as you.
Tried running macro on startup but it seems to wait for 1st form to load before executing ribbon removal. So form still jumps.

Hence why I'm stumped so thought put it to forum.

Michael

[ajetrumpet]

Tried running macro on startup but it seems to wait for 1st form to load before executing ribbon removal. So form still jumps.

take the form name OUT of the access options as the startup form, buddy boy.

that's why it's doing that.

[mapline]

Hi ajetrumpet

Thanks for reply

However if I take it out of the options the form does not load and code does not hide ribbon.

How does that benefit as when it runs the ribbon will hide and form jumps.

Can ribbon be hidden before form loads?

Michael

[ajetrumpet]

yes it can, sir. I don't really wanna type anymore at this point in this thread, so take a look at the attached e.g.

the macro does it all. the code is in MODULE1. if ya have ?'s, post back ok?

[mapline]

Hi ajetrumpet

Thanks for reply and thanks for the amended db.

I tried this route with a macro on starting db.

However the ribbon disappears only on load of the form.

This means that your db example still has jump.
Any thoughts?

Thanks Michael

[ajetrumpet]

I already explained that you can't stop the "jumping" effect when you disappear the ribbon like that, because the screen has to move. See the earlier posts here to read back through that. It's a physical certainty.

I really can't offer anything more here sir. Good luck to ya!

[mapline]

Hi ajetrumpet

Have you used:

Office Button > Access Options > Current Database > Navigation.

It seems that a new ribbon can be created to load but can it also be used to switch off ribbons.

Any knowledge of this route?

Thanks Michael

[mapline]

Hi ajetrumpet
FOUND A SOLUTION!!!!!

Another site on ribbons: http://www.accessribbon.de/en/?Access_-_Ri..._XML___Controls
found good has some downloadable demos and they did not JUMP.

Found reason 1ST FORM MUST BE POP UP and they do no jump.
Great and it looks better as 1st form.

Many thanks for your help and direction.
Michael