HELP - Formating existing report using vba

  • Thread starter Thread starter Graeme Wigg
  • Start date Start date
G

Graeme Wigg

Hi,
I use vba a little as an engineer but I have recently been using msaccess.
I have created my database and a report. The problem is when i try to move
things about aligning things is a pane. I was hoping to write some vba code
to format and view the report, but i am having difficulty understanding the
objects and accessing them. I only want top, left, width and height.

Does any one have a simple code example of how to do this

Regards
Graeme
 
Graeme,

You mean like this...
Me.MyTextbox.Width = 1234

or like this...
Me.MyTextbox.Left = Me.AnotherControl.Left + Me.AnotherControl.Width + 123

A key factor you need to realise is that the unit of measurement is
twips. 1 cm = 567 twips.
 
Back
Top