Solved

In Access control whether image displays

Posted on 2014-04-14
3
397 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

679 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