How to zoom out the contents of a long-text field

[ekje]

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]

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]

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]

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]

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]

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.

 

[isladogs]

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]

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]

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]

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

UPDATE YourTableName SET [My Notes]=Trim([My Notes])

 

[gemma-the-husky]

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]

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.