sætte boks i bunden af en formular og den skal vokse opad...ikke nedad - via VBA

any chance of seeing some code so we can see what your trying to do. or maybe even an example dB ;-)

just had a quick play around ....

If your box is in the form Footer and you want to place the bottom of your box so it is at the bottom of the footer then something like this might work.

NewHeight    is obviously the value your getting from the dB which I am guessing is in twips. (567 twips per centimetre)

      txtBox.Top = Me.FormFooter.Height - NewHeight   
      txtBox.Height = NewHeight

you may need to do some error checking if you want to keep footer dimensions.

Hej Terry..

Der er mail i din indbakke ;o)

Received. I cant see any code where you try resizing pct_test_boks which I assume is the box in question?
Even so, I think you need to take the forms height into account as I do in the example, so you can calculate top.

pct_test_boksen skal blot skifte baggrundsfarve ikke resizes ...

OK, I see its Soejle_1_Vertikal and 2 which you are having problems with. Same applies here, calculate top from height of formdetail and subtract new height

If you dont want to place boxes at bottom of form then you need to have a start point where bottom of boxes is to be placed so the top can be calculated from that

hope you get the idea ;-)

there is a method for moving form which saves a line of code

https://msdn.microsoft.com/en-us/library/office/ff193822.aspx

Se beta 2 af projektet her :
https://1drv.ms/u/s!Aog7vvlTrHB6i9c13u1lLAx9dj0jTA

stor tak til Terry for super input !

mvh martens

Looks good ;-)
And thanks