I assume you mean layout changes based on screen resolution (rather than
monitor size) since monitor size does not impact the screen layout and
cannot impact the screen layout).
Essentially neither Access nor Visual Basic (nor anything I know of) has
automatic facilities for changing layout based on screen resolution. You
have to write code to change the layout based on screen resolution. There
have been some articles on the Internet about how to do it, but it's pretty
messy. There may also be some generic routines floating around the internet
to help you.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.