Recent content by cozzykim

Doh!! Thanks :o

Hi, Trying to add a 'print this report' command button to a report I'm stuck because there is no 'On_Click' event shown in the button properties, could there be a component missing from my Office97 installation? thanks Kim

Hi, Now that I found out how to merge my multi field tables to give me one neat memo field :) is it possible to alter the line spacing in the memo field when it's printed from a report to 1.5 or double spaced? TIA Kim

I can't really use an On_open event because the reports get opened and modified sometimes before completion but I've got some ideas to look at now so I'll explore them a bit, thanks Kim

Thanks Keith, got it (eventually)

Thanks, I'll try that Kim

Hi, I have an old database for generating service reports which has: Report No Date Customer Site In separate fields which is fine but also wrk1 wrk2 wrk3 etc. with a separate field for each printed line on the page I would like to merge all these into one memo field while retaining the...

Hi and thanks, the report is basically a preview of the record to be printed, with company heading and a number of fields that make up a service visit report. They can be viewed at any time but are only printed to accompany an invoice or as a requested duplicate. I normally click "print" in...

Thanks for the reply Ken How could this be done, how about a non printing field on the data entry form "Already Printed?" (I have a lot of previously printed records) with a default value of "Yes" and a drop down box with "No/Yes" then print from a query looking for a "No" ? A bit clunky, but...

Hi all, Is there a way to automatically mark a record when it is printed from a report (to avoid duplicating invoices for example) TIA Kim