Access Report And Image Help

[Joe O]

Is there a way to make a sub Report have gridlines like in a datagrid?

my second problem is I have an image (a jpg file) I need to display on a
report at runtime. I
know the path of the jpg image file (c:\abc.jpg). I have tried to use
LoadPicture syntax using an unbound
image control but I get error I just can't figure how to handle. What is the
right way to do this.

Thanks in advance

Joe

 

[Arvin Meyer [MVP]]

Answers in line:

Is there a way to make a sub Report have gridlines like in a datagrid?

Yes, use borders on all the text boxes and have the sides coincide with the
next textbox.

my second problem is I have an image (a jpg file) I need to display on a
report at runtime. I
know the path of the jpg image file (c:\abc.jpg). I have tried to use
LoadPicture syntax using an unbound
image control but I get error I just can't figure how to handle. What is the
right way to do this.

In the OnFormat event of the section where the image resides, add a bit of
code to an Event Procedure:

Me.ImgControlName.Picture = "C:\abc.jpg"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Joe O]

Thanks Arvin, I appreciate the help.

Answers in line:



Yes, use borders on all the text boxes and have the sides coincide with the
next textbox.


In the OnFormat event of the section where the image resides, add a bit of
code to an Event Procedure:

Me.ImgControlName.Picture = "C:\abc.jpg"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access