moving fields around in a report

  • Thread starter Thread starter CD Tom
  • Start date Start date
C

CD Tom

I have a single report that can have upto 18 columns plus a total column.
The number of columns depend on what the user enters anywhere from 3 to 18.
I'm using a single report with all columns not being used being set to false
in the report format section of the report. What I want to be able to do is
move the total column over next to the last column being printed. Is there a
way to do this, I tried using the me.[columnname].move but it doesn't move
anything. Any help would be appreciated.
Thanks
 
CD Tom,

Try using the Left property of the Totals text box.

You need to be aware that the location you need to provide will be in twips,
like:

Me.TxtBxName.left = 4667

You can do a search in the VBA Help file for more on twips, but basically
you would divide the inches you want by 1440 and that will give you the twips.

Here is a link that may also help.

http://support.microsoft.com/default.aspx/kb/210590
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Subtracting multiple columns from another column 3
Access report design 2
Macro to add numbers in a text string 5
Excel Account Receivable Aging Report 1
Column Property In Reports 3
Moving data between tables 1

Back
Top