Zoom In and Out

Public Function DisplayImage(ctlImageControl As Control, strImagePath As Variant) As String

Dim strResult As String
Dim strDatabasePath As String
Dim intSlashLocation As Integer

With ctlImageControl
If IsNull(strImagePath) Then
.Visible = False
strResult = "No image name specified."
Else
If InStr(1, strImagePath, "\") = 0 Then
' Path is relative
strDatabasePath = CurrentProject.FullName
intSlashLocation = InStrRev(strDatabasePath, "\", Len(strDatabasePath))
strDatabasePath = Left(strDatabasePath, intSlashLocation)
strImagePath = strDatabasePath & strImagePath
End If
.Visible = True
.Picture = strImagePath
strResult = "Image found and displayed."
End If

Sponsored Links:

Related Topics

Stop auto-highlighting on text box Zoom
I have a text box with a memo control source, when you click the text box an acCmdZoomBox is run. However when the Zoom box opens it highlights all of the data, which is causing issues with people accidentally deleting all the information. I have seen something about a selstart, sellength command, but I don't know how to refer that to a zoom box.
Also is it possible to carriage return on a Zoom Box memo, or even text box


Create a Zoom Button
Is there any way to create a Zoom Button on a form that will open the Zoom form normally activated by the Ctrl-F2 command while in a text or memo field


Builiding a custom Zoom Box to display a large amount of data...
Microsoft's built in zoom box allows viewing a large amount of data in a pop up dialog form. I don't like it's looks at all, so I want to do the same thing except using a slicker custom form, Form1. A single click or a double click on any field on Form1 opens the custom form, Zoom.
Database3 is where my existing Table1 and the existing form I would like to customize with the new zoom box are located.

Zoom would have a large memo field to display the data. Users can add or change data and when the OK button is clicked on Zoom, the updated field data is saved for that field.

Does anyone know how to do this so I can copy the code into my existing form, or create a new one with this functionality


Custom Zoom Form Not Updating Data
I have some code tied to the double click event for a control that opens a custom zoom form and displays the text as well as the label of that control. Right now, if I add to the text in the zoom form, it doesn't actually update the data in the table. I know I've read somewhere how to accomplish this, but my searching isn't finding it again.


Edit Data in Zoom-In Control
While designing a Form, Report or Query certain properties of these objects we can Zoom in and edit the property values in a big window, like Record Source Property, Filter or Order By property etc. When you right-click on these properties a Shortcut Menu will open up with the Zoom... option in it and when clicked we can edit the property values comfortably in a big window.


Use Zoom Box For Inserting Large Amount Of Data
Many a times while entering data into database tables, we need to enter a large amount of data in single cell. Since Access 2010 table columns length has to be set first to view all the entries being written, you can use Zoom box instead to enter the data. Zoom box will be helpful especially when you need to insert large amount of data that cannot be displayed properly in control box.


Design View
I am very new to Access and have not been able to find a way to be in Design View and zoom in to align text fields. I have used another database that allowed me to zoom inand out to see how the details.


Pan and Zoom Images
I have a Microsoft Access 2007 application that displays images in an image frame. I would like to be able to pan and zoom the images. Is there a way to do that? If so how is it done?


Allow Users to Zoom into Comment Fields
Find out how to Allow Users to Zoom into Comment Fields. (video tutorial)


Zooming in on a Form Image
I created a Form where I display a JPG image using the following code:

Me![DRImageFrame].Picture = Me.[DRIP]

This works great.

If I view the same JPG using "Windows Picture and Fax Viewer I am able to zoom in on the image. And so my question is, is there a way I can zoom in on the JPG image from within the Access Form


zoom in for a closer in design view
In design View 2007
Is there a way to zoom in for a closer view so I can do better aligning of fields?


How to control the tables added to the relationship layout interface?
How to control the tables added to the relationship layout “interface”?

I’m wondering why the relationship interface is still missing many tools that help in performing the work more efficiently. The interface misses the following (comparing with what we have in the ArcGIS software)
1. Pan tool
2. Zoom in/out too
3. Zoom all tool
4. Automatic arrangement


report zoom in center
I have a report
click a cmd button open the report
in zoom100% but at the left side of the screen
but I want it in the center of the screen


Microsoft web browser ole class object : form vs report
What the difference is between 'microsoft web browser' ole class object embedded in a microsoft access form and 'microsoft web browser' ole class object embedded in a report.

this code works fine :

Private Sub Form_Open(Cancel As Integer)
gmap.Navigate URL:="http://maps.google.com/staticmap?center=" & latitude & "," & longitude & "&zoom=14&size=512x512"
End Sub

this one does not at all :

Private Sub Report_Activate()
gmap.Navigate URL:="http://maps.google.com/staticmap?center=" & latitude & "," & longitude & "&zoom=14&size=512x


Creating a zoom effect on a chart
I'm using Access 2003.

I have a chart showing daily sales over a two year period. Currently when I open the form I see the full two year history which is good because the user gets an overall picture but I want the user to be able to click on a section of the chart and see it in greater detail.


Switch to Access 2007 and pictures are distorted
I have a report that links to a picture. It displayed great in earlier versions of access, but when I switched to 2007, the pictures are displayed but they look like they are posterized. They print just fine. I use an image frame, zoom size mode and centered. They are fairly substantial jpegs (2 megs), but regardless, it is the change to Access 2007 that caused the problem.


Losing Changes in Query Expressions
When I make changes to a query expression (usually in zoom) and click OK, I often lose the changes. It may be due to incorrect syntax, but I don't get a notification saying so, just lose the changes. If the syntax is wrong creating a new expression, I get a pop up, but not for changes Is there a setting I need to change? Very frustrating to think I made a change and have the query results be incorrect


Why is my report showing like this?
I have created a report (Distance Between Localities), which unfortunately, sums the averages of distances between locations, whilst I would not like to aggregate the distances, but rather display either
a) one of the distances e.g. first, last
b) the average distance

Database at [LINK] named, Transport Malta.

Office Access 2007

I am using Mozilla FF, and, noted that when trying to browse Microsoft Answers using Google Chrome the default display is sosmall that I hurriedly switch browser rather than bothering to zoom the time.


Print Preview Report
I have assigned a macro to a button that opens a report in print preview mode. When the report opens it is set at "Fit" in the tool bar and I have to zoom to 100% to see the data properly. Is there any way I can adjust the macro code or report properties to open the report at


Previewing a Microsoft Access report sized using acCmdZoom
When we open a Microsoft Access report in Print Preview we have options available to us about how we would like to see and view the report on the screen. We can use the Zoom options on the Print Preview toolbar to allow us to resize the preview of the report to make it easily visible.