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
 
Back
Top