specifying column widths?

Hi,

I have a data analysis program which outputs 8 rows and 20 columns of data into an excel file. However, I want to also provide the summary data on screen as well and I put a picture box and used the print command. The trouble is that only 14 columns of data fit in the picure box (window & picture box are maximised etc...). The space between the columns in the picture box are a bit too big so all i need to do is specify a smaller width between columns if that's possible. Here's the code that writes the data to the picture box.

PicSummary.Print "Summary"
For r = 1 To TotRun Step 1
PicSummary.Print r, 'no new line!
For i = 1 To 20 Step 1 'cycle through some bins

PicSummary.Print TotScore(r, i), 'no new line!
Next i
PicSummary.Print "|" 'new line!
Next r 'Loop the file

Anyone know?

Thanks in advance.
S. :)

I haven't really been thru your code or tried to understand it yet but why don't you more simply use a msflexgrid and print it ?

I haven't really been thru your code or tried to understand it yet but why don't you more simply use a msflexgrid and print it ?


Quite new at programming so MS FlexGrid seemed a little too far at this point. Just hoping that when I was using a simple picture box & printing the columns there would be some way of specifying how far apart the data would be.

I'll have a look at the Flex Grid thing but if anyone knows what it is that I am talking about then please post a reply.

Thanks.
S.

Although I'm quite sure the flexgrid would be less hassel, here is a way out of your problem

Put a frame on your form.
Put your picturebox in then frame
put a vertical and horizontal scrollbar attached to yout frame

your picture box size beeing bigger than your frame, part of it will be hidden,
All you have to do is code in the change of the scroll by modifying the top of your picbox for vertical scrolling and left for horiz. scrolling