05-29-2019, 11:28 PM
|
#1
|
|
Newly Registered User
Join Date: Jan 2016
Posts: 53
Thanks: 19
Thanked 1 Time in 1 Post
|
Font Size
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? 
|
|
|
|
05-30-2019, 04:21 AM
|
#2
|
|
I’m here to help
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,562
Thanks: 38
Thanked 869 Times in 852 Posts
|
Re: Font Size
Hi. No, I don’t know of any function that does that. Sorry.
__________________
Just my 2 cents...
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
|
|
|
05-30-2019, 04:50 AM
|
#3
|
|
Part time moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,760
Thanks: 107
Thanked 2,642 Times in 2,418 Posts
|
Re: Font Size
Nor me. Out of interest why/how would you put an address in a date field?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
|
|
|
|
05-30-2019, 04:52 AM
|
#4
|
|
Newly Registered User
Join Date: Jan 2016
Posts: 53
Thanks: 19
Thanked 1 Time in 1 Post
|
Re: Font Size
data not date d'oh... sorry
|
|
|
|
|
05-30-2019, 05:00 AM
|
#5
|
|
Part time moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,760
Thanks: 107
Thanked 2,642 Times in 2,418 Posts
|
Re: Font Size
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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
|
|
|
|
05-30-2019, 05:34 AM
|
#6
|
|
Super Moderator
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
|
Re: Font Size
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
__________________
Dave (Male!)
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
|
|
|
|
|
The Following User Says Thank You to gemma-the-husky For This Useful Post:
|
|
|
05-30-2019, 05:41 AM
|
#7
|
|
Newly Registered User
Join Date: Jan 2016
Posts: 53
Thanks: 19
Thanked 1 Time in 1 Post
|
Re: Font Size
Thanks Dave,
Unfortunately it is an older version of access (V3.0) and my system hates it and wont open it.
|
|
|
|
|
05-30-2019, 06:13 AM
|
#8
|
|
Super Moderator
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
|
Re: Font Size
Hmm
different problem. I can't download it, and I can't find my old downloads from the site.
__________________
Dave (Male!)
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
|
|
|
|
|
The Following User Says Thank You to gemma-the-husky For This Useful Post:
|
|
|
05-30-2019, 06:50 AM
|
#9
|
|
Newly Registered User
Join Date: Jan 2016
Posts: 53
Thanks: 19
Thanked 1 Time in 1 Post
|
Re: Font Size
Thank you for trying
YouTube let me down.. its normally very good
|
|
|
|
|
05-30-2019, 08:14 AM
|
#10
|
|
Enthusiastic Amateur
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,845
Thanks: 411
Thanked 688 Times in 667 Posts
|
Re: Font Size
Quote:
Originally Posted by MaleNurse325
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
__________________
Access novice. Sometimes trying to give something back.
Access 2007
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
|
|
|
|
05-30-2019, 09:23 AM
|
#11
|
|
Super Moderator
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
|
Re: Font Size
were you able to download it, or did you already have it?
__________________
Dave (Male!)
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
|
|
|
|
|
05-30-2019, 10:03 AM
|
#12
|
|
Newly Registered User
Join Date: Feb 2019
Posts: 194
Thanks: 321
Thanked 16 Times in 16 Posts
|
Re: Font Size
Quote:
Originally Posted by gemma-the-husky
were you able to download it, or did you already have it?
|
I downloaded it just now.
|
|
|
|
|
05-30-2019, 10:12 AM
|
#13
|
|
Part time moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,760
Thanks: 107
Thanked 2,642 Times in 2,418 Posts
|
Re: Font Size
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/m...ols/4594549378 in post #2 of that thread
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Last edited by isladogs; 05-30-2019 at 10:21 AM.
|
|
|
|
|
The Following User Says Thank You to isladogs For This Useful Post:
|
|
|
05-30-2019, 01:14 PM
|
#14
|
|
Enthusiastic Amateur
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,845
Thanks: 411
Thanked 688 Times in 667 Posts
|
Re: Font Size
Quote:
Originally Posted by gemma-the-husky
were you able to download it, or did you already have it?
|
Just downloaded it Dave.
I've attached it here, just in case.
__________________
Access novice. Sometimes trying to give something back.
Access 2007
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
Rate This Thread |
 Linear Mode
|
|
All times are GMT -8. The time now is 12:23 PM.
|
|
