Font Size (1 Viewer)

MaleNurse325

Registered User.
Local time
Today, 13:03
Joined
Jan 11, 2016
Messages
67
Hi guys and ladies,

I have a report with a large date field that has an address in it.
Is there a function that I can use that will increase the font size to fit all of the available space in the field?:banghead:
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:03
Joined
Oct 29, 2018
Messages
21,358
Hi. No, I don’t know of any function that does that. Sorry.
 

isladogs

MVP / VIP
Local time
Today, 20:03
Joined
Jan 14, 2017
Messages
18,186
Nor me. Out of interest why/how would you put an address in a date field?
 

isladogs

MVP / VIP
Local time
Today, 20:03
Joined
Jan 14, 2017
Messages
18,186
What you could do (by trial and error) is find out how many characters fill the textbox at different font sizes. Then create your own user defined function to count the total characters used and adjust the font sizes accordingly.

There have been threads where the opposite was required - reduce font size to fit in space available ...try a forum search starting with the similar threads below
 

MaleNurse325

Registered User.
Local time
Today, 13:03
Joined
Jan 11, 2016
Messages
67
Thanks Dave,

Unfortunately it is an older version of access (V3.0) and my system hates it and wont open it.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 20:03
Joined
Sep 12, 2006
Messages
15,614
Hmm

different problem. I can't download it, and I can't find my old downloads from the site.
 

MaleNurse325

Registered User.
Local time
Today, 13:03
Joined
Jan 11, 2016
Messages
67
Thank you for trying
YouTube let me down.. its normally very good
 

Gasman

Enthusiastic Amateur
Local time
Today, 20:03
Joined
Sep 21, 2011
Messages
14,047
Thanks Dave,

Unfortunately it is an older version of access (V3.0) and my system hates it and wont open it.

V3 is the version of the DB, not Access. It was built with 2003.

Here is a 2007 version. I just opened and saved after conversion.

HTH
 

Attachments

  • AutoSizeTextBoxVer3.accdb
    384 KB · Views: 145

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 20:03
Joined
Sep 12, 2006
Messages
15,614
were you able to download it, or did you already have it?
 

isladogs

MVP / VIP
Local time
Today, 20:03
Joined
Jan 14, 2017
Messages
18,186
Stephen's utility in the link provided (& converted by Gasman) works in a slightly different way.
It adjusts the size of the textbox according to the amount of text entered - it doesn't change the font size.

You may have meant his auto font size utility which is the idea I was referring to in post #2 http://www.lebans.com/autosizefont.htm
I have attached an ACCDB version of that (done in A2010)

Alternatively the OP could consider using a zoom box as in the first similar threads link below. I referred to my example app http://www.mendipdatasystems.co.uk/move-forms-controls/4594549378 in post #2 of that thread
 

Attachments

  • AutoSizeFontVer2.accdb
    528 KB · Views: 117
Last edited:

Users who are viewing this thread

Top Bottom