glad tat u replied! I want to have a form to allow me to input 2 figures (length & width) so that a gris can b plotted. For example, a big sheet of paper size is length 30" x width 8", if first figure 10" (length) is input, it will plot 3 lines across 30" (cos 30" divided by 10" equals to 3) and same goes to width. Is it clear? Thanks.
sorry I can only show you the way to do it. I don't have time to write actual code at the moment, because I'm checking this forum at work. but your form will need 2 textboxes and 1 button. when user clicks the button it will open the report. and all calculatiing and drawing stuff will be done in the report's on page event.
Since you want to help me writting some codes, I also have to do something rather than just sit & wait.Pls check my attachment for better understanding.
Can you fine tune it so that the grid can be drawn inside the OLEBound300:? And the grid also must be plotted according to the big size & cut size, is it all right? Thanks.
that's an advanced example. I didn't know you can use regular Vb forms in Access. so I'm newbie on this subject as much as you are.
I didn't know that either. I've used them in Excel but have never seen them in Access. I can think of many uses for vb Userforms. Check this out explains how to add a user form. You can go to customise Toolbar to get the userform button and add it to the insert menu. Check this out:
seanyeap, have you thought of using an activeX control on a Form? There's the MS Office Spreadsheet object that gives a grid just like an excel sheet on a form. I'm sure this could be minipulated with VB to change size if needed.