Move controls on report open event

[antvon]

Hi all

Is it possible for me to programmatically move controls on
a report in any section before it loads or opens.
As in :

Private Sub Report_Open(Cancel As Integer)
Me.txt386.Left = 26
End Sub

Thanks

 

[dhookom]

I generally move controls in the On Format event of the section containing the controls. This works very well as long as you don't move the controls beyond the section boundaries/margins.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[antvon]

Hi Duane

Thanks for your reply.I appreciate it.

Quite right. On Format event is better and
I have moved the code there.
I have found that the original event works too, but
that I had used a value that made little difference in
the position

Me.txt386.Left = 26

When I look in the properties of the control I had it
as Left = 26.306cm but in code I have to make it in excess
of 13000 just to get close to the same position. Do you perhapes know what measuring basis this is? (points,pica,?)

Thanks again

Anton

 

[dhookom]

I believe the default measurement is in twips. There are 1440 twips per inch or 567 per centimeter.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[antvon]

Thanks Duane

I can setup some conversion function.
I appreciate your response.

Regards

Anton