Font Size

[MaleNurse325]

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]

Hi. No, I don’t know of any function that does that. Sorry.

 

[isladogs]

Nor me. Out of interest why/how would you put an address in a date field?

 

[MaleNurse325]

data not date d'oh... sorry

 

[isladogs]

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

 

[gemma-the-husky]

Stephen Lebans used to have a routine that worked the other way - shrunk text to fill a text box.

I imagine if you checked you could get it to go the other way.

http://lebans.com/autosize_textbox.htm

 

[MaleNurse325]

Thanks Dave,

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

 

[gemma-the-husky]

Hmm

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

 

[MaleNurse325]

Thank you for trying
YouTube let me down.. its normally very good

 

[Gasman]

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

 

[gemma-the-husky]

were you able to download it, or did you already have it?

 

[deletedT]

were you able to download it, or did you already have it?

I downloaded it just now.

 

[isladogs]

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

 

[Gasman]

were you able to download it, or did you already have it?

Just downloaded it Dave.

I've attached it here, just in case.