Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-06-2019, 11:42 AM   #1
ekje
Newly Registered User
 
Join Date: Jan 2014
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
ekje is on a distinguished road
How to zoom out the contents of a long-text field

Hi,

The report contains a small text box control (only one-line high) for a long-text field.
The long-text field could contains e.g. twenty lines of text.
How could I zoom out the contents of the long-text field while reading/watching the text of the long-text field?
Thank you for your reply.

ekje is offline   Reply With Quote
Old 05-06-2019, 11:50 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,707
Thanks: 57
Thanked 1,259 Times in 1,240 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: How to zoom out the contents of a long-text field

Hi. You said you're using a report to view the data, is this correct? If so, are you using the Report View or Print Preview?
__________________
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 online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
ekje (05-07-2019)
Old 05-06-2019, 11:52 AM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,940
Thanks: 114
Thanked 2,993 Times in 2,721 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: How to zoom out the contents of a long-text field

The easiest way is to use the built in Access zoom box. Press Shift+F2 whilst the textbox is selected.

If you want something more than that. you can create your own zoom form. For example see the first three forms in the example app linked to this article http://www.mendipdatasystems.co.uk/m...ols/4594549378

EDIT
Sorry.. Just read your post again. My answer is for zoom on a form

__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.
isladogs is offline   Reply With Quote
Old 05-06-2019, 12:10 PM   #4
ekje
Newly Registered User
 
Join Date: Jan 2014
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
ekje is on a distinguished road
Re: How to zoom out the contents of a long-text field

Quote:
Originally Posted by isladogs View Post
The easiest way is to use the built in Access zoom box. Press Shift+F2 whilst the textbox is selected.

If you want something more than that. you can create your own zoom form. For example see the first three forms in the example app linked to this article http://www.mendipdatasystems.co.uk/m...ols/4594549378

EDIT
Sorry.. Just read your post again. My answer is for zoom on a form

Ok.
But is there a zoom-out control for designing a report which has a long-text field? Thank you for your reply.
ekje is offline   Reply With Quote
Old 05-06-2019, 12:19 PM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,940
Thanks: 114
Thanked 2,993 Times in 2,721 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: How to zoom out the contents of a long-text field

Although not its intended purpose, you can also use Shift+F2 on any text control on a report provided it is used in Report View. You cannot interact with a report viewed in Print Preview
__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.
isladogs is offline   Reply With Quote
Old 05-06-2019, 12:56 PM   #6
ekje
Newly Registered User
 
Join Date: Jan 2014
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
ekje is on a distinguished road
Re: How to zoom out the contents of a long-text field

Quote:
Originally Posted by isladogs View Post
Although not its intended purpose, you can also use Shift+F2 on any text control on a report provided it is used in Report View. You cannot interact with a report viewed in Print Preview
Thank you for your reply.
I tried to use Shift+F2 on the text control ("My notes ) and a window opened
but without any text, although the long-text field ("My notes") contains
several text lines. (-> please see the attachment).
Why is the window empty without text?
Sorry, the database text is in Finnish. The names of the fields are in English.
Attached Files
File Type: pdf Shift+F2_on_any_text_control.pdf (66.7 KB, 11 views)
ekje is offline   Reply With Quote
Old 05-06-2019, 01:21 PM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,940
Thanks: 114
Thanked 2,993 Times in 2,721 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: How to zoom out the contents of a long-text field

The field appears to be blank in all the records you have displayed

However, there appears to be something very small in your zoom box.
Check the font size isn't something like 1pt. Increase as necessary

__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
ekje (05-07-2019)
Old 05-07-2019, 12:52 AM   #8
ekje
Newly Registered User
 
Join Date: Jan 2014
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
ekje is on a distinguished road
Re: How to zoom out the contents of a long-text field

Quote:
Originally Posted by isladogs View Post
The field appears to be blank in all the records you have displayed

However, there appears to be something very small in your zoom box.
Check the font size isn't something like 1pt. Increase as necessary
Hi,
Yes, the the field is blank because the text begins on the line 2 accidentally.
But the reason was the font size as you mentioned above!
I enlarged the font size and now the long text is visible!
Thank you very much for your help!
ekje is offline   Reply With Quote
Old 05-07-2019, 01:01 AM   #9
ekje
Newly Registered User
 
Join Date: Jan 2014
Posts: 15
Thanks: 3
Thanked 0 Times in 0 Posts
ekje is on a distinguished road
Re: How to zoom out the contents of a long-text field

Quote:
Originally Posted by theDBguy View Post
Hi. You said you're using a report to view the data, is this correct? If so, are you using the Report View or Print Preview?
Hi,

Yes, I use the Report View. And using Shift+F2 the small text control is zoomed out and the long text is visible.
Thank you for your reply.
ekje is offline   Reply With Quote
Old 05-07-2019, 02:11 AM   #10
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,940
Thanks: 114
Thanked 2,993 Times in 2,721 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: How to zoom out the contents of a long-text field

Quote:
Originally Posted by ekje View Post
Hi,
Yes, the the field is blank because the text begins on the line 2 accidentally.
But the reason was the font size as you mentioned above!
I enlarged the font size and now the long text is visible!
Thank you very much for your help!
Glad you got it sorted.
If you want to remove the blank line at the start, use the Trim function in an update query. Something like
Code:
UPDATE YourTableName SET [My Notes]=Trim([My Notes])
__________________
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
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.
isladogs is offline   Reply With Quote
Old 05-07-2019, 04:02 AM   #11
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,791
Thanks: 55
Thanked 1,027 Times in 993 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: How to zoom out the contents of a long-text field

It might be an issue with Access. Both IslaDogs and myself have recently observed that a zoombox was opening with 1pt fonts. I wonder if it's to do with rich-text fields being used in a database.
__________________
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-07-2019, 06:38 AM   #12
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,707
Thanks: 57
Thanked 1,259 Times in 1,240 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: How to zoom out the contents of a long-text field

Quote:
Originally Posted by ekje View Post
Hi,

Yes, I use the Report View. And using Shift+F2 the small text control is zoomed out and the long text is visible.
Thank you for your reply.
Hi. Congratulations on finding a solution. Good luck with your project.

__________________
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 online now   Reply With Quote
Reply

Tags
long-text field , report

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In-text citations in long text field Harry Paraskeva Forms 5 02-08-2019 02:20 AM
carriage returns not showing up in text field(long text) MilaK Forms 3 09-06-2017 06:04 AM
Question importing multiple rtf documents into rich text format long text field. niawo General 2 07-05-2017 02:50 AM
Text in field is too long to see grunder General 5 10-17-2011 03:53 AM
long text field yogi Modules & VBA 13 03-30-2007 07:11 PM




All times are GMT -8. The time now is 06:59 PM.


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