Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-29-2019, 11:28 PM   #1
MaleNurse325
Newly Registered User
 
Join Date: Jan 2016
Posts: 55
Thanks: 19
Thanked 1 Time in 1 Post
MaleNurse325 is on a distinguished road
Talking 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?

MaleNurse325 is offline   Reply With Quote
Old 05-30-2019, 04:21 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,492
Thanks: 58
Thanked 1,420 Times in 1,401 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
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.
theDBguy is offline   Reply With Quote
Old 05-30-2019, 04:50 AM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,256
Thanks: 115
Thanked 3,077 Times in 2,795 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
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)
isladogs is offline   Reply With Quote
Old 05-30-2019, 04:52 AM   #4
MaleNurse325
Newly Registered User
 
Join Date: Jan 2016
Posts: 55
Thanks: 19
Thanked 1 Time in 1 Post
MaleNurse325 is on a distinguished road
Re: Font Size

data not date d'oh... sorry
MaleNurse325 is offline   Reply With Quote
Old 05-30-2019, 05:00 AM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,256
Thanks: 115
Thanked 3,077 Times in 2,795 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
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)
isladogs is offline   Reply With Quote
Old 05-30-2019, 05:34 AM   #6
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,821
Thanks: 56
Thanked 1,030 Times in 996 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
MaleNurse325 (05-30-2019)
Old 05-30-2019, 05:41 AM   #7
MaleNurse325
Newly Registered User
 
Join Date: Jan 2016
Posts: 55
Thanks: 19
Thanked 1 Time in 1 Post
MaleNurse325 is on a distinguished road
Re: Font Size

Thanks Dave,

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

MaleNurse325 is offline   Reply With Quote
Old 05-30-2019, 06:13 AM   #8
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,821
Thanks: 56
Thanked 1,030 Times in 996 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
MaleNurse325 (05-30-2019)
Old 05-30-2019, 06:50 AM   #9
MaleNurse325
Newly Registered User
 
Join Date: Jan 2016
Posts: 55
Thanks: 19
Thanked 1 Time in 1 Post
MaleNurse325 is on a distinguished road
Re: Font Size

Thank you for trying
YouTube let me down.. its normally very good
MaleNurse325 is offline   Reply With Quote
Old 05-30-2019, 08:14 AM   #10
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,516
Thanks: 440
Thanked 841 Times in 812 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Font Size

Quote:
Originally Posted by MaleNurse325 View Post
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
Attached Files
File Type: accdb AutoSizeTextBoxVer3.accdb (384.0 KB, 24 views)
__________________
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.
Gasman is offline   Reply With Quote
Old 05-30-2019, 09:23 AM   #11
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,821
Thanks: 56
Thanked 1,030 Times in 996 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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.
gemma-the-husky is offline   Reply With Quote
Old 05-30-2019, 10:03 AM   #12
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 326
Thanks: 518
Thanked 24 Times in 23 Posts
Tera will become famous soon enough
Re: Font Size

Quote:
Originally Posted by gemma-the-husky View Post
were you able to download it, or did you already have it?
I downloaded it just now.
Tera is offline   Reply With Quote
Old 05-30-2019, 10:12 AM   #13
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,256
Thanks: 115
Thanked 3,077 Times in 2,795 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
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
Attached Files
File Type: accdb AutoSizeFontVer2.accdb (528.0 KB, 15 views)
__________________
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.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Tera (05-30-2019)
Old 05-30-2019, 01:14 PM   #14
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,516
Thanks: 440
Thanked 841 Times in 812 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Font Size

Quote:
Originally Posted by gemma-the-husky View Post
were you able to download it, or did you already have it?
Just downloaded it Dave.

I've attached it here, just in case.
Attached Files
File Type: zip AutoSizeTextBox.zip (45.3 KB, 16 views)

__________________
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.
Gasman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
change textbox size or font size in continuous form basilyos Forms 1 04-21-2019 01:21 AM
Listview Font Size? bjreb Modules & VBA 1 02-10-2012 07:49 PM
Font size 127 razorking Reports 1 04-23-2009 10:08 AM
Reducing the font size horizontally without change the font size vertically prasanta4u2 Crystal Reports 0 09-18-2008 10:48 PM
Font Size Tansar General 2 06-03-2003 08:30 AM




All times are GMT -8. The time now is 04:54 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World