Design resolution question

[MadTom]

My database was designed on my pc 2736x1824 resolution and 200% scale, win10 64 SP4. I would like to share my database with others and they may have a problem with viewing the forms. How would you go about changing the forms and what resolution should I use? (800x600). Could I do a main page the has the option for different resolutions? I've changed my settings and have looked at forms in different resolutions, I see the problem with user with lower resolutions.
Thanks
Tom

[isladogs]

Suggest you look into using automatic form resizing http://www.mendipdatasystems.co.uk/a...g-1/4594554784

[MadTom]

What would be the best or easiest way to change the resolution of a form? Would you work on existing form or start with a new form and cut and paste? Would it be best to work in properties? I'm still looking into other resizing apps, do any of them change the form's resolutions and then let you can save for that setup?
Thanks,
Tom

[isladogs]

Its obviously easiest to start using AFR with new forms rather than try to alter an existing form.

However you can use the FixFormSize procedure on a copy of your form.
That will reduce the size of all controls as well as shift them all towards the left/top.
Then reduce the form width/height accordingly.

If necessary repeat that more than once to reduce the form to a suitable size.
Save and open normally with the resize code added.
You may have to do some tweaking to get it perfect.

I know of no other code that will change the resolution for you.
In fact there are very few alternatives
You can try Shrinker Stretcher by Peter's Software but its commercial software.
Some people like it. I was less impressed.

[MadTom]

AFR only seems to work with mdb files, I'm using Access 365 and using a accdb file. When I export I only see mdb?

[isladogs]

AFR works with all types of Access file: ACCDB, ACCDE, ACCDR, MDB, MDE.
Not sure what you mean by 'when I export I only see MDB'

[MadTom]

Maybe I'm doing something wrong. I downloaded afr.accdb into my Access folder.
When I open it.
INSTRUCTIONS:
1. Click on the "Export" button below.
2. Locate your database using the "open" button on the export form.
3. Click on "Export Module" button.
4. Now open your database.
5. If you have designed your database forms at any resolution other than 640 X 480 then you must prepare the modResizeForm module as follows:-
more ...

[isladogs]

You appear to have downloaded the original code by Jamie Czernik from 2003.

Instead download the example app ResizeFormExample_v2.6.zip from the same web page
That app includes all you need including an updated version of the resizing code with many changes that I have made over the years

[MadTom]

I'm just getting the hang of it, had to change some grouping and move somethings around.
Still lots to learn with this download.
Thanks for your help!
Tom