Adjust size of txtbox on mainform

[bodylojohn]

Hello everyone,

I have a mainform (frmMAIN) and on frmMAIN the is a subform (frmSUB1).
frmSUB1 is a datasheet consisting out of 2 columns.
Directly above frmSUB1 there are 2 txtboxes. Each txtbox filters on a column of the datasheet. So far this works great ;-).

However.. when a user adjest the with of the columns of the datasheet (frmSUB1) I want the width of the textboxes automatically to adjust.

How can I do this?

Thanks in advance!

 

[ajetrumpet]

my guess is that this is not worth the effort. why do this? I am also wondering if you can even DO it. if i'm not mistaken, adjusting a column on a datasheet form has nothing to do with the actual size of the field textbox of that same column when viewed in single or continuous form view. if that is so, then it probably can't be done.

 

[ChrisO]

Small quick demo attached.

 

[bodylojohn]

Small quick demo attached.

Thank you very very much..

Exactly what I am looking for...

And everybody who helped me with my other access problems.. THANK YOU TOO!!!

I wish all off you a very happy and healthy 2010