Zoom function crashes DB (1 Viewer)

markdooler

Member
Local time
Today, 04:46
Joined
Nov 25, 2020
Messages
58
Hi All

Trying to get the zoom function to work so that my team can expand a notes field to read the full detail.

i am using the Shift + F2 function and the moment but will implement the VBA once it works.

so some screen shots.

1619109756527.png


This is the split view form that i use (i have redacted the information as this is live data).


1619109853716.png

1619109881364.png

1619109910405.png


This is the properties for the form

1619109976475.png


This is the view i get when i use the zoom.

As you can see it is completely unreadable.

When i click on font to make it bigger, the db crashes and closes.

This happens on all occasions.

Any ideas?

Thanks

Mark.
 

Attachments

  • 1619109833108.png
    1619109833108.png
    29.4 KB · Views: 154

Ranman256

Well-known member
Local time
Today, 00:46
Joined
Apr 9, 2015
Messages
4,339
if zoom crashes don't use it, instead make a form with a single large textbox ,
user can click a button to send the info to the large text box.
open it via:
docmd.openform "frmNotes",,,"[id]=" & me.txtID
 

markdooler

Member
Local time
Today, 04:46
Joined
Nov 25, 2020
Messages
58
if zoom crashes don't use it, instead make a form with a single large textbox ,
user can click a button to send the info to the large text box.
open it via:
docmd.openform "frmNotes",,,"[id]=" & me.txtID
Yea i did consider this but thinking i wanted something less cumbersome lol
 

markdooler

Member
Local time
Today, 04:46
Joined
Nov 25, 2020
Messages
58
if zoom crashes don't use it, instead make a form with a single large textbox ,
user can click a button to send the info to the large text box.
open it via:
docmd.openform "frmNotes",,,"[id]=" & me.txtID
Ok so i have done this and set the double click event to open the notes form.

Any ideas how i dynamically anchor this to the relevant line in the dataset?
 

Users who are viewing this thread

Top Bottom