Form's Close button

[GraeagleBill]

I have a form with explicit conditional "SAVE" and "CANCEL" command buttons enabled or hidden that serve to control when the form closes. I can't seem to get Access to completely turn off the form's control box commands. (see pic)



I have both "Control Box" and "Close Button" set to "No". What else needs to be disabled? One would think I'd encountered this situation long before now!

[June7]

I set those properties and the icons completely go away. Cannot replicate issue.

Might also want to set MinMaxButtons to None.

[GraeagleBill]

Might also want to set MinMaxButtons to None.

Yes, I had done that already.


I wonder if the MS Acct Avatar that is included in that area has any baring?


Uploaded the source to an Access 2010 system and it does the same thing.

[June7]

And how did you accomplish that avatar? What is the dropdown to the left?

[GraeagleBill]

And how did you accomplish that avatar?

It just showed up after having provided an image to my Microsoft Account. When I port the source to a A2010 system on another computer I just see a place-holder where the avatar otherwise appears. Again, I have no idea if the avatar has any baring on why I can't get the min/max close to become invisible.

Here's a snippet of the drop-down screenshot:

[June7]

I have no idea what that is.
I use Access 2010 and don't see anything like that, not even a 'placeholder'.
This have anything to do with Office365?

[GraeagleBill]

This have anything to do with Office365?

Not that I can detect. I checked the apps list in Win 10 Pro but don't see anything "the cats dragged in". My Win 10 Pro is at 1809, as is the system where I checked.

On my Win 10 Pro Office 2003 system, only the Min/Max button appears. Plus a search window in place of the Avatar seen on both the A2010 and A2013 systems.

Something has changed somewhere! Setting the Control Box to "NO" should have taken care of this issue.

I can successfully execute this statement:

Me.ControlBox = False

but not these:

Me.CloseButton = False
Me.MinMaxButtons = 0

I get a 2136 Runtime error:

[June7]

I use Windows 10 Home and Office 2010.

Sorry, cannot replicate this issue.

Why would an Access form have a dropdown option for "Switch account"?

[Micron]

That's a good one. Not that I really needed a reason to not bother with an account image, but it seems I have one now. I've known for a long time that my account name shows up in the application title bar. I wonder if they ever noticed that according to the mandatory last name field in the subscription form that my surname is Withheld?

Your subscription should entitle you to free technical support, no? Pretty sure it does.

[isladogs]

I have an image associated with my MS account. My account name appears in the title bar using Office 365 but the image doesn't.

[GraeagleBill]

Your subscription should entitle you to free technical support, no? Pretty sure it does.

I'll pursue sometime next week.

I haven't tested the event firing sequence yet, but hopefully I can do something like Mouse_Down and look at KeyCode for vbKeyClose so I can evaluate whether the conditions for a record SAVE/CLOSE have been satisfied. I tried to attend to the needed functionality in the Close Event but it's too late to get the answers needed in code......... like the current record has already been released.

Continuing.............

I can't find anywhere that allows me to specifically detect a MouseDown on the form's close control. If someone could answer that question it would be helpful. Maybe one of the other events? OnUnload? OnDeActivate? before the OnClose fires?

As it is "Me.ControlBox = False" or "Me.ControlBox = True" has no effect on my form when executed in code, only when set in design view. And, Access does not allow me to toggle enabling the close button in code so it's like having one hand tied behind my back!

The whole discussion about the display of the Window User's Avatar was a distraction relating to the OP. It does not seem to have any baring on the ControlBox issue.