423,485 Members | 1,664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,485 IT Pros & Developers. It's quick & easy.

Microsoft 2016 Form Control Box

P: 11
Setting Control Box to No only works when I click Restore Form (but I can't maximize to fit the screen first).

If I disable either the close button, or the minimize or maximize button, I get "SwatchBI" instead of the box, x or -. Then when I hover over one of the active buttons, it says a different label (i.e. hover over - says restore instead of minimize).


The SwatchBI doesn't impact anything, but my users don't like it.
2 Weeks Ago #1
Share this Question
Share on Google+
19 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,605
I presume you have already tried DoCmd.Maximize?
2 Weeks Ago #2

P: 11
Yes I've used docmd.maximize, docmd.restore. If I set the control box to no, it only disappears when I restore the form, but I prefer to maximize the form when it's opened. Then I don't want users to have any control over minimizing the form or closing it.

I don't know how to insert the image that I have saved.
1 Week Ago #3

P: 11
Also, this seems to only be an issue in Access 2016 - it hasn't appeared in prior versions.
1 Week Ago #4

twinnyfo
Expert Mod 2.5K+
P: 2,605
I set Control Box to No, Close Button to No and Min Max Buttons to None. Then, I control any resizing and shaping if needed through VBA. I also include a Command Button to close the form. I never allow my users to access the regular built-in controls on the Forms. It's a good way for you to control what happens in your DB.
1 Week Ago #5

P: 11
I do the same programming - I just don't understand the SwatchBI labels that show instead of the greyed out minimize, maximize or close buttons.

This is occurring at a client site and I just got a new computer with Access 2016 installed. I created a small form with only a close button and the same thing occurs.
1 Week Ago #6

twinnyfo
Expert Mod 2.5K+
P: 2,605
Could you post an image of the "SwatchBI" you are seeing?

I'll be honest and tell you I have no idea what you are talking about.
1 Week Ago #7

P: 11
I'd like to post an image but don't know how. When I click on insert image it wants a URL.
1 Week Ago #8

twinnyfo
Expert Mod 2.5K+
P: 2,605
When you start you post, click the Advanced button and then you can upload an image
1 Week Ago #9

P: 11
Here is the image. Thank you.

Attached Images
File Type: jpg Untitled.jpg (9.7 KB, 132 views)
1 Week Ago #10

PhilOfWalton
Expert 100+
P: 1,353
I suspect either your Database is corrupted, or Access is corrupted.

Am I correct in saying this occurs on more than 1 form in your database?

Have you tried creating a new database and add a form (create one, do NOT import it). What happens? If you get the same problem, I would suspect Access as being corrupt.

If there is no problem, try importing the "dodgy" form from your existing Db. What happens?

Phil
1 Week Ago #11

P: 11
Not the database or Access. I just purchases a new laptop with Access 2016, created a blank database and a simple form with the same results. This is happening at a client site as well as on my own computer.
1 Week Ago #12

PhilOfWalton
Expert 100+
P: 1,353
Is your client using his own database, or is it a database you have supplied?

Is your copy of Office 2016 from the same source as your Client's copy of Office?

I use Access 2016, and judging by the responses from this site, nobody has ever come across this problem.

I have Office Professional Plus 2016, Version 1808, Build 10730.20102 Click-to-Run

Phil
1 Week Ago #13

twinnyfo
Expert Mod 2.5K+
P: 2,605
Yeah - never seen anything like this before. A smaller image would have been helpful though.....

:-P

;-)
1 Week Ago #14

P: 11
Different versions of Access and it's not only on databases I created (I've created a number of databases for a number of clients and have only seen this recently with Access 2016). Thanks for trying. Sorry about the size of the image - I did what I could as I had never posted on Byte before. I've googled on lots of sites and thought I'd give this a shot. It's very strange, but doesn't impact anything.
1 Week Ago #15

twinnyfo
Expert Mod 2.5K+
P: 2,605
It looks more like an application glitch than anything else. I'm leaning toward Phil's thoughts that your Access application is corrupt.
1 Week Ago #16

P: 11
2 separate access applications on 2 completely separate systems are corrupt? Sounds strange.
1 Week Ago #17

P: 11
It appears to be an issue with using overlapping windows. I changed to Tabbed documents and unchecked display document tabs. Now the control box appears to be irrelevant which is what I wanted (and the image with SwatchBI no longer appears).
1 Week Ago #18

P: 1
I have over 50 separate installations where I can see this same "swatchBI" next to the minimise buttons in separate copies of different access databases.
I do not believe this to be a database or application corruption but more to do with the controls around managing windows, but this has just appeared recently with the latest updates from microsoft.

This leads me to think that there has been a function disabled causing this glitch.
5 Days Ago #19

P: 11
ReluctantDev, Thank you for confirming the issue! Changing to tabbed documents and not viewing the tabs fixed the problem for me.
5 Days Ago #20

Post your reply

Sign in to post your reply or Sign up for a free account.