Size of Datasheet (1 Viewer)

[snehal0909]

Is there any way you can specify the size of a datasheet?

Say the datasheet opens up with 600x800 size?
or 10cm x 15cm?

 

[boblarson]

Kind of... if you use a form and in the form's On Open event set the form's Inside Width and Inside Height in Twips (remember it is 1440 twips to an inch).

 

[snehal0909]

I am a bit too new, could you pls tell me how to? (WHAT TO TYPE & WHERE)

 

[boblarson]

This shows you where to put it (but instead of On Current select the On Open event instead):
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx

Also, you would use:

Me.InsideHeight = 1440 * 5 ' (substitute the number of inches for the 5 I put there for what works for you)
Me.InsideWidth = 1440 * 5 ' (again, substitute the value that works for you).

 

[snehal0909]

Thanks boblarso, it worked!

 

[boblarson]

Great! Glad we could help.