Change width of Object Box to data value

[Niroth]

Hi,

I have a form with start date and end date and I'm trying to create a visual for the duration, so I would like to add a box that will change the width according to the duration in each row. I have this, but it does not work, not sure why? Can you help me? Thank you.

Private Sub Form_Load()

Me.durationBox.Width = Me.durationW

End Sub

 

[pbaldy]

What value does durationW contain? If memory serves, the width property would be set with twips.

 

[Minty]

Also - I don't think this would work on a continuous form - you mentioned each row

 

[pbaldy]

I didn't notice that; it would set all rows the same on a continuous form. You could do it on a report.