How to remove blank image spaces from access report

[mb60]

Try setting your SQL of the supReport's recordsource to:

SELECT [Question Bank].ID, [Question Bank].Image
FROM [Question Bank]
WHERE ((([Question Bank].Image) Is Not Null));

The Is Not Null clause will ensure you only get results when there is something in the image field.

Sorry for disturbing you once again. How to use the code given by you in setting SQL of the sub-report?

[ADezii]

You are definately not disturbing me, mb60. The code has absolutely nothing to do with defining the SQL for the Sub-Report. The code will dynamically re-position the Image Control and all Controls below it based on whether or not the Image Control actually contains an Image. The Detail Section of the report will be resized (shrunk) accordingly.

[mb60]

Try setting your SQL of the supReport's recordsource to:

SELECT [Question Bank].ID, [Question Bank].Image
FROM [Question Bank]
WHERE ((([Question Bank].Image) Is Not Null));

The Is Not Null clause will ensure you only get results when there is something in the image field.

sir
your technic worked. removed the blank spaces. but images of all records are appearing in the sub report even though they are not selected by using yes/no check box option.
inspite of writing the entire code I used the ' is not value' in the criteria of query.

[TheSmileyCoder]

Well im kinda guessing here, since your post isn't that accurate.

Remember that a subreport must be linked to your main report. Select the subreport from within the main report, and select its properties. You should see "Link Child Fields" and "Link master fields". Clicking the 3 small dots on the right should allow you to set the link criteria. In this case you want to link via ID in main report to ID in child report.

[mb60]

Well im kinda guessing here, since your post isn't that accurate.

Remember that a subreport must be linked to your main report. Select the subreport from within the main report, and select its properties. You should see "Link Child Fields" and "Link master fields". Clicking the 3 small dots on the right should allow you to set the link criteria. In this case you want to link via ID in main report to ID in child report.

Sir
As you directed I carried out the changes in my database. It is successful.
my sql is as follows

SELECT Table1.ID, Table1.Q, Table1.[1], Table1.[2], Table1.[3], Table1.[4], Table1.im, Table1.im.FileD ata, [im].[FileFlags] AS Expr1, Table1.im.FileN ame, [im].[FileTimeStamp] AS Expr2, Table1.im.FileT ype, [im].[FileURL] AS Expr3, Table1.sel
FROM Table1
WHERE (((Table1.im.Fi leName) Is Not Null) AND ((Table1.sel)=-1));

I have a check box named as 'sel' for each record. suppose if a record without image is selected it is not appearing in the report though it has text. I request your help to overcome this problem

Thank you