Textbox expanding and shrinking

[arunakumari02]

Can anyone help me to make the textbox expand and shrink?

 

[pbaldy]

Have you looked at the Can Grow and Can Shrink properties of it?

 

[arunakumari02]

I checked Yes in MS-Access properties.

This is actual queation.

I have 2 textboxes say box1, box2 (which has year) on the grid which has month Jan, Feb, ...Dec etc.

When I scroll the horizontal bar forward, box1 should shrinks and box2 should expand.

For example: initially when I open the form, box1 shows current year(say 2008) and box2 should be invisible.

When I scroll forward, box1 should shrink and box2 should expand.

Any hint is really appreciated.