Picture on report

G

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
 
A

Arvin Meyer [MVP]

Gargamil said:
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.
Click to expand...

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
 
G

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: [email protected]
 
Top