Forms resized in Access 2007

[M_S_Jones]

Hello,

I'm working with a DBMS that I created in Access 2002. When I make amendments to it, I use Access 2002, as do some of its users. However, some users run the file using Access 2007, and it seems that every time I make changes to the file in 2002 and put the front end on their machine, the forms are a resized to be much bigger than they are when displayed in 2002. The objects stay the same size, but the forms are made bigger, which results in the all of the objects being displayed off-centre. If I then change the form sizes using 2007 they will stay at this new size until I open the file in 2002, and then again in 2007. Is there a way of saving the file in 2002 so that the form sizes stay the same when opened in 2007?

Thanks,

Matt

 

[missinglinq]

I don't think the problem is what version of Access the app is being run under! What you posted is the classic description of what you get when you develop an app on a machine with one screen resolution set, then run it on a machine that has the screen resolution set higher! My guess would be that the machines running ACC2007 are newer and hence have a higher screen resolution as the default.

If this is the case you need to use a function to upsize the forms on the higher resolution machines. Here're links to a few of the more popular ones:

http://jamiessoftware.tk/resizeform/afr.exe

http://www.lebans.com/hscroller.htm

http://www22.brinkster.com/accessory/forms/006.shtml

It's good to note that they work better in upsizing forms rather than downsizing them, so develop in the lowest screen resolution (usually 800 x 600 today) that you're apt to run into.

 

[boblarson]

Actually, it COULD have to do with the way Access and the new Tabbed form view is working. Have someone in 2007 change it like this:

http://www.btabdevelopment.com/main...tochangefromtabbedforms/tabid/81/Default.aspx

 

[M_S_Jones]

Thanks for the responses.

I started by trying the easiest suggestion (boblarson's), but actually all of the machines that use 2007 already have their settings like that. So I then tried missingling's suggestion and it works, to an extent. I used the Form Resizer from Jamie's Software website. I followed the instructions set the variables in the module to match my screen dimensions (1440x900). However, all of the users are using 1280x1024 monitors, which results in the forms getting a bit squashed when they are resized. I've played around with the settings and that's not too bad. But I have encountered a strange anomaly, I'm not sure that it's to do with the Form Resizer, but perhaps the process of installation, since I do not experience this on the backup version of the application. Here's what happens: Just generally using the system on a user's machine with Access 2007 on it, one of the forms doesn't load, just displays a white box in the shape of the form. If I change this to design view and then back to form view, it works fine. Also, some of the data entry forms suddenly have values in the boxes on load and some of the records in the test data that I'm using were deleted from the table, for no apparent reason. It didn't tell me that it was doing it, I just noticed that queries weren't returning many matches. I looked in the table and a lot of the records are gone.

I've tried the system on my own machine using Access 2007 and none of these problems are encountered. I've compacted and repaired the application using my Access 2007 and the ones of the user's machines that I have tested it on. Can anyone think what settings could be causing this? I installed Access 2007 on my machine, but not on the others, so I wondered if this problem could be because of the other machines having different settings.

Any help would be very much appreciated.

Thanks,

Matt

 

[M_S_Jones]

I've found why the records were being deleted: one of my forms has a delete query on its cancel button. For some reason ever since I installed the Form Resizer, this form opens with values already in it. It's odd because the default value property of each of the objects doesn't have a value in it. The values that are now displayed on open are from a record in the table, so when I click cancel, it deletes that record. Next time I go in another record is there and that will get deleted when I press cancel.

Has anybody got any idea why installing the Form Resizer has caused these values to be displayed as default for that form? Since submitting my last post, I've tested this file on another computer and it behaves the same on that one too. I've also tried a backup of the file from before the Form Resizer was installed, and that doesn't behave in this manner.

 

[boblarson]

Not sure about it, but if you could post a copy we could take a look.