05-29-2019, 11:28 PM
|
#1
|
Newly Registered User
Join Date: Jan 2016
Posts: 55
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: 6,492
Thanks: 58
Thanked 1,420 Times in 1,401 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
|
High Noon Moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,256
Thanks: 115
Thanked 3,077 Times in 2,795 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.
Colin (Mendip Data Systems) 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.
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. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
|
|
|
05-30-2019, 04:52 AM
|
#4
|
Newly Registered User
Join Date: Jan 2016
Posts: 55
Thanks: 19
Thanked 1 Time in 1 Post
|
Re: Font Size
data not date d'oh... sorry
|
|
|
05-30-2019, 05:00 AM
|
#5
|
High Noon Moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,256
Thanks: 115
Thanked 3,077 Times in 2,795 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.
Colin (Mendip Data Systems) 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.
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. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
|
|
|
05-30-2019, 05:34 AM
|
#6
|
Super Moderator
Join Date: Sep 2006
Location: UK
Posts: 13,821
Thanks: 56
Thanked 1,030 Times in 996 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: 55
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,821
Thanks: 56
Thanked 1,030 Times in 996 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: 55
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: 4,516
Thanks: 440
Thanked 841 Times in 812 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
Please, please use code tag # when posting code snippets
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, 09:23 AM
|
#11
|
Super Moderator
Join Date: Sep 2006
Location: UK
Posts: 13,821
Thanks: 56
Thanked 1,030 Times in 996 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: 326
Thanks: 518
Thanked 24 Times in 23 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
|
High Noon Moderator
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,256
Thanks: 115
Thanked 3,077 Times in 2,795 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.
Colin (Mendip Data Systems) 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.
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. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
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: 4,516
Thanks: 440
Thanked 841 Times in 812 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
Please, please use code tag # when posting code snippets
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.
|
|
|
Thread Tools |
|
Display Modes |
Rate This Thread |
Linear Mode
|
|
All times are GMT -8. The time now is 04:54 AM.
|
|