Problem with text box positioning

[Zuzu]

Hello

I have been playing around with a timeline report database i found which populates a report in a fashion similar to a gantt chart.

I can get most of it to work, but am having a problem for the grow box to position itself correctly.

If you look at the attached example, for Event 2, the size of the box is correct, but the positioning is wrong.

Where or how would i change the VBA to get the growbox text field to position itself correctly?

Cheers

Zuzu

 

[JHB]

Try it now.

 

[Zuzu]

G'day JHB

Was wondering if you were going to have a look at this problem!

Once again, very appreciative for the assistance, you are a fantastic forum user that has helped me countless times!

I see what you did toi fix it, however don't understand why that fixed the problem???


Secondly, i nearly have the report working as i want it, but there seems to be one more problem.

If you look at the attached file, you will notice that 2nd, 3rd and 4th bookings are all for the same time period (26/12/16 - 25/01/17).

The label result displays correctly (31 days)... however the box width is not working for correctly for Unit FL032, where is it is working correctly for the other 2 records.

Do you know what the problem is here?

Cheers

Zuzu

 

[JHB]

The problem is when the width of the controller makes a part of it is placed outside the report.
See the example in the picture.
That you do not get any error messages is because you are using the worst type of error handling "On error Resume Next". Do always turn of the error handling until your code runs perfect.