Printing Problems.... 1

[KarloZ]

hello guys, i need you advice. i'm having problem with printing. to give you a view/idea, the program uses a small printer for stores. i made a report and is not generating a receipt that should stop printing or using the paper when it reaches the end of the record for the detail section. that is why the result is a big blank in between detail section and footer. is there a way to solve it. i badly need your help. thanks guys in advance!

apcarlos

 

[RickSpr]

Make sure you set the Can Grow and Can Shrink properties of the Detail section, and of all the controls that have variable height, to Yes. I think you probably forgot to do that for the Detail section. Rick Sprague

 

[KarloZ]

i tried your suggestion RickSpr but no success. there is still a big gap on th report between detail and footer...i set all the objects that have can grow, can shrink properties to yes....still same result.

 

[RickSpr]

Maybe I misunderstood you. Now that I read your messages again, it appears that you want to make the footer rise up to just beneath the detail.

Is your footer a report footer, a page footer, or a group footer? If you make it a group footer, it should print right after the detail. The other two types print at the bottom of the page, and I don't know how you can change that.

Are you using paper from a continuous roll, or cut sheets? If you're using continuous paper and you hope to make it stop spacing up to the full page length, moving the footer won't work. It will just space up after the footer instead of before it. The problem isn't Access, it's Windows. Printer drivers, so far as I know, always work with a page length. It might help to define the page as short as possible, with no page or report headers or footers (you can use a group header for the page header), and with the top and bottom margins set to 0 if possible. Rick Sprague

 

[KarloZ]

can i change the setting of the page report through code?
1] margins 2] centering of the the field value on the header part
how is that possible? i've read about prtdevmode, prtmip: are these the commands that i need? give me some ideas? i wanted to create my report that will be compatible with the settings of all printers, is that possible? thanks..

 

[KarloZ]

i mean a report that will match settings of whatever size of printer it is. because right now i dont have model of the small printer that they will use. i just want to make sure that my report is ok when they will use it. thank you a lot in advance. any help is greatly appreciated

 

[RickSpr]

The PrtMip, PrtDevMode, and PrtDevNames properties are available to help you do this, but I warn you, it's just a hair above directly coding to the Windows API. However, it sounds like you're making a commercial product here, so it might be worth the investment for you to learn how.

On the other hand, it's too complicated to go into in any depth here (and I haven't had a lot of experience with it anyway). I would strongly recommend you purchase a copy of Access 2000 Developer's Handbook by Getz, Litwin, and...uh..(hmm, I never can remember that last name). It has very good coverage of these printer properties, and practical, reusable code you can incorporate, royalty-free, into your own professional-grade products. (You'll also find lots of tricks you never thought were possible in Access! My favorite is making mailing labels start in the middle of a page, so you don't have to waste half a page of laser labels all the time.)

Anyway, yes, I think you can detect the settings for the seleted printer in Access, and make appropriate modifications to the report. Rick Sprague

 

[smedvid]

Also, those printer settings are stored somewhere... Perhaps there is an API library call that can be executed to read the settings for each printer.... Although, I've never seen one... Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[KarloZ]

also, im getting problems still with the space. it seems that the can shrink can grow only works for the fields but not the section of the report. i still got this space in between page footer and detail. is there still away to remove it? i really appreciate all the nice ideas and suggestions i'm receving from you guys. thank you and alot thanks in advance.

 

[RickSpr]

When you say "section" here, are you talking about the actual Section part of the form, like the Detail section? Or are you talking about the part of the report that displays data from one of your tables? I was assuming the latter.

Did you read my earlier suggestion that you set the Detail section's CanShrink property to Yes? Rick Sprague

 

[KarloZ]

yes, i'm talking about the detail section and i did set can (shrink and grow) to yes... are there more properties i need to set? thanks?

 

[RickSpr]

Whoa! Carefully reading you previous post, you said "i still got this space in between page footer and detail."

You must not have carefully read what I wrote earlier, so I'll reproduce it here: "Is your footer a report footer, a page footer, or a group footer? If you make it a group footer, it should print right after the detail. The other two types print at the bottom of the page, and I don't know how you can change that."

The only way to change the position of a page footer is to change the length of the page. As I said before, make the page length as short as practically can. You'll still get a gap and waste a little paper most of the time, but the gap will be minimal. Rick Sprague