Form Design Changes - Long Delay When Saving
Hello Everyone, I’m new to this forum and appreciate any help others might be able to provide. I recently developed an Access database with a form that includes buttons which when clicked run queries and displays the results. Nothing special, just basic queries. However, any time I save a change to the form design (add a button, change the text of a label, etc.) or change from form design to form view, it takes anywhere from 7-10 minutes. If I modify or create a new query, saving those updates only take a few seconds. It is just when trying to save a form that takes a very long time. Some facts about the database: Using the latest version of MS Access provided with Office 365. Using a split database with the front-end on a local PC and the back-end on a network server. There are ten tables linked to ten .csv files on the network server. Total size of the front-end database is 1,444 kb Total size of the back-end database is 14,736 kb Perform Name AutoCorrect has been deselected. Track Name AutoCorrect is still selected. I’ll be happy to provide any additional information if it will help. Any thoughts on what may be causing the issue? Thanks in advance. Pete
Labels automatically resizing in form design - Access 2019
Hi, Not sure if it is just me not seeing a setting somewhere. In previous versions I cannot remember this happening but it is rather annoying. When in design mode of a form, if I change the text in a label, the label automatically resizes. Is there a global setting to turn this off? This is only relevant AFAIK to Access 2019, I use 2016 on desktop when in the office or using company laptop and do not have this issue. Basically my use is within a suite of database front ends I have developed, they all have the same type of form design so I can copy a form which does a similar function from one of the databases when building a new one to add into the suite. All my labels are nicely sized so everything is uniform, but when I type a different text into the label (e.g. change from Order Number to Employee Name) the label resizes itself and I have to then resize the label again so that it fulfils the requirement of my OCD. Added a couple of example images. In image 1 I have taken a form which is used to add employee skills, made a copy and now changing this to add in an absence. Changing the label text automatically resized the label meaning I have to then go manually resize it to what it was previously. Hope that is enough info. Sensible answers only please. I could write VBA or use Access 2016. I only require a response if there is a way to do this or not, and if possible how to prevent it from happening. Thanks in advance.