thanks dhookom, simple but effective. your suggestion worked perfectly for me.
thanks also kjv1611, i've been trying VBA using movelayout, nextrecord, etc. but i can't get them right.
Are you trying to edit a query result? If you really must override, convert your output into a table then do the editing on the output table.
Hope I got your problem correctly.
Access 2003: My report generates a paragraph that reads:
...... "requests payment in the amount of "
& bill_amount
& spell_number(bill_amount)
& " representing expenses for the period "
& format(effdate_from)
& format(effdate_to)
I contained them all as an expression in one textbox. However...
Access 2003: I need to generate Statement of Account on a half-sheet (2 statements should fit on a letter-size paper). I want the 2 statements equally laid out. Access2003 doesn't allow me to create a custom-size paper (the footer section should have solved my query). Number of detail lines...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.