Picture on report

[Gargamil]

Is it possible to dynamically size a picture on a report? The idea is that
if there is no picture the allocated space shrinks down to nothing so I
don't get whitespace. Conversely if there is a picture it sizes to a
predetermined height.

g

 

[Arvin Meyer [MVP]]

Is it possible to dynamically size a picture on a report? The idea is that
if there is no picture the allocated space shrinks down to nothing so I
don't get whitespace. Conversely if there is a picture it sizes to a
predetermined height.

You can use the format event of the report to size the control from code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Gargamil]

Hello, Arvin!

Got you. Works like a treat, thanks.


You wrote on Fri, 4 Nov 2005 06:04:35 -0500:

AMM> ??>> Is it possible to dynamically size a picture on a report? The idea is
AMM> that
??>> if there is no picture the allocated space shrinks down to nothing so
??>> I don't get whitespace. Conversely if there is a picture it sizes to
??>> a predetermined height.

AMM> You can use the format event of the report to size the control from
AMM> code. --
AMM> Arvin Meyer, MCP, MVP
AMM> Microsoft Access
AMM> Free Access downloads
AMM> http://www.datastrat.com
AMM> http://www.mvps.org/access


With best regards, Gargamil. E-mail: (e-mail address removed)