How to zoom out the contents of a long-text field (1 Viewer)

ekje

Registered User.
Local time
Today, 02:00
Joined
Jan 8, 2014
Messages
34
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.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:00
Joined
Oct 29, 2018
Messages
21,357
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?
 

isladogs

MVP / VIP
Local time
Today, 09:00
Joined
Jan 14, 2017
Messages
18,186
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/move-forms-controls/4594549378

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

ekje

Registered User.
Local time
Today, 02:00
Joined
Jan 8, 2014
Messages
34
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/move-forms-controls/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.
 

isladogs

MVP / VIP
Local time
Today, 09:00
Joined
Jan 14, 2017
Messages
18,186
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
 

ekje

Registered User.
Local time
Today, 02:00
Joined
Jan 8, 2014
Messages
34
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.
 

Attachments

  • Shift+F2_on_any_text_control.pdf
    66.7 KB · Views: 270

isladogs

MVP / VIP
Local time
Today, 09:00
Joined
Jan 14, 2017
Messages
18,186
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
 

ekje

Registered User.
Local time
Today, 02:00
Joined
Jan 8, 2014
Messages
34
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

Registered User.
Local time
Today, 02:00
Joined
Jan 8, 2014
Messages
34
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.
 

isladogs

MVP / VIP
Local time
Today, 09:00
Joined
Jan 14, 2017
Messages
18,186
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])
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 09:00
Joined
Sep 12, 2006
Messages
15,613
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.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:00
Joined
Oct 29, 2018
Messages
21,357
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.
 

Users who are viewing this thread

Top Bottom