By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

Printing different sizes to the form

P: 2
Hi All,

i have a ms access form (invoice) it scans a barcode brings up the description, price, qty, total. Header is date, invoice number, customer. Footer subtotal, discount, grand total.

Is there anyway that when i open the form (invoice) that it can display the the line details in a much larger font ie, filling most the the screen, but when i press the print invoice button that it will revert back to the normal size in order for it to print onto a4 paper?

Maybe a way to mirror the line details innto another scaled down form? ro VBA code.

Jan 19 '19 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,494
Use a Form for displaying on the screen and a (separate) Report to print off the details.
Jan 19 '19 #2

P: 2

thanks for your reply, this wouldn't be possbile as the person going to be using it wouldn't know howto do that!

I had it setup whereby the invoice opens up and goes to the barcode line where they scan the code and put in the quanity, calcs on footer. them a simple button saying print invoice. But they find that the data lines are too small so they wanted it bigger.

Is it possible to make the columns bigger and mirror my form and do the adjustments in there?
Jan 20 '19 #3

Expert Mod 15k+
P: 31,494
If you have a button on the form then the capabilities of the user shouldn't matter. You design it. They click a button. Simples!
Jan 20 '19 #4

Expert 100+
P: 1,430
Neopa, as usual is spot on.

Don't forget that a form is generally in landscape format (shape of the monitor) and I presume you want the A4 report in Portrait format.

So the form should be designed to look neat and tidy, and have the cursor moving logically from 1 textbox to the next. So don't follow customer's surname by post code.

After your entry is complete, the data is saved to 1 or more tables (frequently using a query to update those tables)

The report extracts the information from those tables with it's recordsource being very similar to the recordsource of the form.
The layout of the report again must be designed to be easily read and neat and tidy. It has absolutely nothing to do with your form, so you can add information that is not on the form, like date printed, No of pages, your company logo and address etc.
Choose suitable sizes & styles of fonts to make it easy to read (I rarely use less than 12 point fonts)

Jan 21 '19 #5

Expert Mod 2.5K+
P: 3,284
And, always design your databases as if the peson using it has absolutely no knowledge of "how to use a database". Your design should create a user interface that is intuitive and easy to use, such that, the user simply sits at their screen clicks and types whatever it is that is required to add, modify or manipulate the data. They should never see the guts behind the scenes--nor should they care about them.
Jan 22 '19 #6

Post your reply

Sign in to post your reply or Sign up for a free account.