Solved

In Access control whether image displays

Posted on 2014-04-14
3
392 Views
Last Modified: 2014-04-14
Have an Access Report where the record source is a table (Tbl_xyz) having 2 text fields.

Tbl_xyz records are:

ID    Field 1     Field 2
1     Blue         (Null)
2     Green      c:\green.jpg
3     Brown     (Null)

Would like report to list all records in Detail section, but for record #2 display the image located in Field 2 and then proceed to contents of record #3. So, I inserted an Image Control in the detail section and made the control source Field 2.

By inserting an image control in the detail section, the image frame creates additional space in those lines where there is no image. Is there a way to conditionally make that image frame visible? In other words, records #1 and #3 don't have images.  I don't want the space created by the image frame to be visible. Thanks!
0
Comment
Question by:clock1
  • 2
3 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 40000605
Try this code in the Format section of the detail section:

If Len(Me.Field2.Value) > 0 Then
  Me.Detail.Height = 1000
  Me.Image1.Height = 500
Else
  Me.Detail.Height = 500
  Me.Image1.Height = 250
End If

Just change Image1 to the name of the image control in your report and the height values to what you need.

Flyster

P.S.
Thanks for the previous points!
0
 

Author Comment

by:clock1
ID: 40000625
Flyster

Points were well deserved, and you're welcome.
Is your suggestion to use code in the image property, or On Current event of Report, or On Print event of Detail section?
0
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 40000633
In design view, right-click the detail section of your report and select properties. Under the event tab, select On Format and paste the code there.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question