moving fields around in a report

[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

 

[Mr B]

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