Recent content by DeanRowe

I do see your point wiklendt, and had never looked at the situation from that side before - lesson learned. Thank you again for your help.

Hi JohnLee, I had considered that option as a worst case scenario but was looking to see if there were any alternatives - the report is redesigned frequently and so I worry that I'll have to redesign the report twice, or more likely the person who takes over the database after myself won't...

Thank you very much Robjoy, the Alt-163 worked perfectly. wiklendt, you have no idea the time I have spent trying to figure out this problem, no idea. I had found the information you had mentioned on Google, and plenty of other information - but messing around with underlying database...

Thank you for your post, I've taken a look at the settings and nothing jumps out at me to suggest it would be possible. The other problem with this option would be I would have to set the report to just one or the other. For example "ReportOne" would have to be "PDF" only, or "lexmark" only.

Hi, I have a standard Laser Printer called "Lexmark" which I obviously use to print my reports onto paper. Occasionally I need a PDF copy so I open the report, click "Print..." and select my "PDF Printer" to make a PDF version I'm now requiring equal amounts of printed paper reports and PDF...

does anyone have any ideas yet? I've tried entering in every symbol that I can see on the keyboard but none of them result in the "£" symbol.

Thank you very much indeed CarolW, it was right there infront of me, I looked over it at least half a dozen times - thank you again CarolW.

I did used to print to pdf and then send the pdf in an email to our suppliers, however they complained that they couldn't select the text and copy it to easily load it into their system. So I changed the macro to "output" the report to a text file, which then opens up automatically and I copy...

Hi, Does anyone know how to change the properties of a multi-lined text box so that when you press the enter box, it moves down to the next line, rather than moving to the next text box. At the moment I hold down Control + Enter to move down to the next line, but I want to do the same without...

Anyone had any luck with this problem yet? I've tried typing in lots of random symbols but no luck a yet.

Hi Jon, No I'm afraid I've had to live with it so far. As Rich suggested, I would have thought that changing the underlying field to currency would resolve the problem. However I had a previous problem where the rounding up and down of calculations wasn't working properly, it took me absolutely...

Hi Rich, We used to fax our orders over to our supplier - so when the order was complete a command button printed out a report with various data. However our supplier now requires them to be emailed rather than faxed - so I've changed the coding to export the report into a txt file that pops...

Sorry George, I'm in the UK, the "£" symbol is on the number 3 key on our keyboard. Currently I have code on my report that looks like this: ="Total Inc VAT & Delivery: £" & [TotalIncVAT] When its viewed as a report it shows this: Total Inc VAT & Delivery: £126.76 However when I export the...

Hi, I'm trying to export a report to a text file. The report contains a pound "£" symbol, however when it is exported into a .txt file the symbol appears as a "œ". Does anyone know how I can stop this from happening, or the symbol that would make a "£" appear. Thank you. Dean

beautiful! thank you very much indeed - cooking on gas again!! thank you!!!