Search results for query: *

Thanks for the replies. I was aware of the New Page property, but because this is a Sales Quote and a number of them fit on one page, I didn't want to have to resort to that. Is there a reason why this isn't working? Thanks again, Mike

I am using Access 2000 on a Windows 2000 Professional machine and have a small problem. I have a Report Footer with 8 lines of totals only, which consist of 8 labels and 8 text boxes. I would like to keep them all on page. If they can't all be printed at the bottom of one page, I would like...

That's the ticket! I'm not sure why it doesn't work from the recordsource but this does. I guess I could have done the following as well: DiscountPrice: IIf([hdwrDiscountPrice]=0,"",Format(DiscountPrice, "$#,##0.00")) The Function is much cleaner and takes up less space...

Thanks for the reply. I have tried it with the function in the report as well as in a class module within the database, and I get the same results. The datatype of DiscountPrice is double, but the function also gets called if Qty is passed and thats defined as a integer. I have tried it both...

I am using Access 2000 on a Windows 2000 Professional machine, and am having a slight problem when using a function for my recordsource on certain text boxes. I have done this before but can't remember what I did to make it work (it's been a few years since I used Access). I have a number of...

Thanks for the reply, Warwick. I tried that and it does work to a certain degree. Unfortunately, the height difference is very noticeable. Anybody else? Is there a way for me to not print an entire line in the detail section? It will always be the 2nd line of a two line detail section, if the...

I have searched the archives and have read some of the topics on this but am not sure if they pertain to me. I have a Detail section with two lines of 7 identical text boxes. The first line has Hardware Item information (item, description, qty, retail, discount pct, discount price, extended...