Text display size on forms

[carrod65]

Hi,

I have a simple access database that is split between a backend on a networked drive, and a front end users transfer to their local machine.

Both backend and front end are .mdb files and were originally created on (I believe) the 2010 version of Access. We are currently using Office365 so the database currently opens with that version of Access.



When my new employee opens the database, the font size is so small that it's nearly unreadable, no one else has this issue.

Any idea how to fix this?

His windows display settings are currently at 150%, access is showing a default 11 point font size. I'm not sure what other settings might be controlling this but I feel like I may be missing something simple.

[CJ_London]

is it just the font? i.e. is it a small font in a large textbox control? or are the controls also small?. Alternatively if this is a datasheet view, it may be your users has changed the font size for datasheets - click on one of the fields and check the font size on the home ribbon

As an aside, .mdb was replaced with .accdb in access 2007. Further since access 2013, earlier versions of .mdb's cannot be read - so at some point your mdb's will cease to work with your current version of access, particularly if you are using the subscription basis. I would advise upgrading to .accdb before it is too late.

[Micron]

What about monitor resolution compared to a pc that the db looks normal on? If the db was created in a resolution that is the same as the "normal" ones and the new guy's is much higher res, then everything will appear smaller. Setting magnification to 150% might make the db more readable on the problem pc, but will blow up everything else he/she looks at.

As mentioned, if you're saying that the controls for all users are the same size but it's just that the font itself is smaller for only one person then it's not a resolution thing.

[carrod65]

is it just the font? i.e. is it a small font in a large textbox control? or are the controls also small?. Alternatively if this is a datasheet view, it may be your users has changed the font size for datasheets - click on one of the fields and check the font size on the home ribbon

As an aside, .mdb was replaced with .accdb in access 2007. Further since access 2013, earlier versions of .mdb's cannot be read - so at some point your mdb's will cease to work with your current version of access, particularly if you are using the subscription basis. I would advise upgrading to .accdb before it is too late.

1) Its everything on the form. The field names, the text boxes, and any free text created associated with that record.
2) Thank you for pointing this out. I will see if we can get this updated in the near future to try to prevent issues down the road.

[carrod65]

What about monitor resolution compared to a pc that the db looks normal on? If the db was created in a resolution that is the same as the "normal" ones and the new guy's is much higher res, then everything will appear smaller. Setting magnification to 150% might make the db more readable on the problem pc, but will blow up everything else he/she looks at.

As mentioned, if you're saying that the controls for all users are the same size but it's just that the font itself is smaller for only one person then it's not a resolution thing.

The database has been around for along time so I would assume it probably was created in a 800x600 resolution monitor or something older like that.

That being said, both myself and the affected colleague have 1920x1080 resolution monitors and we actually tried changing the resolution on his monitor but the text was always very small and nearly impossible to read.

Thanks all for your suggestions.

[CJ_London]

perhaps you can send some screenshots of the problem computer and the same shots on a working computer

[isladogs]

Consider using automatic form resizing. That will increase the size of all form objects and font size dependant on screen size and resolution.
I have a detailed tutorial on this at http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/459455478.
The article includes all required code and an example app