Microsoft Access Resize Form Fields Dynamically with VBA Video Tutorial

In this Microsoft Access video tutorial, you will learn how to dynamically change the size of a form field when the user clicks on it (or tabs to it). This will allow you to make certain fields (like Notes, for example) to appear much larger when needed. For more free Access tutorials and a discount on my full lessons, visit 599cd.com/XYTRF

[@joseluisbeltramone599]

Loved your tutorial. Thanks for sharing!

[@599CD]

My pleasure.

[@FestivaleOnline]

Very nicely explained, and well paced. I love that you added the tip to call another routine. I'm going to use it to create a conditional field size based on content. Fun times.

[@599CD]

Thanks

[@nta699]

Very nice and practical.

[@johndavy3820]

Very Helpful, Thanks Richard

[@599CD]

My pleasure.

[@tombates1435]

I love that automatic expand/contract idea. I definitely will use that and include your name and website in the code comments. :-) Thanks!

[@599CD]

Much appreciated! Feel free to send me screen shots! :)

[@carlo9567]

Thank you. That was very useful.

[@599CD]

You're very welcome.

[@EarlAndJill]

Very good instruction - clear ... thank you so much !

[@599CD]

Glad you enjoyed it!

[@sweed1sa]

thanks
and that was very usefull 4 me
keep them coming please.

[@jairalt]

The zoom box was good to know it behaves like word.. then the users wont need to use ctrl enter for a new line.

[@josephmessina5689]

I like that video. That is really cool. I use access a lot for few databases. I'm always watching the different videos u have on youtube!

[@599CD]

Glad you like them!

[@josephmessina5689]

@@599CD i'm always on youtube to see different things I can do in my databases in Access!

[@tnguyen657]

Thanks for your video! What if I didn't want to add the buttons though? I tried to use the same steps but eliminated adding the command box. However it didn't come out right. What am I do wrong?

[@599CD]

599cd.com/Ask

[@mohammedlabib4493]

I am asking if you have any code for inserting frame with scroll bar in to access form and add text boxes in this frame reading data from tables

[@599CD]

Huh?

[@MrSidCharming]

Would you have a suggestion to have the width match the longest data point in a comboBox?

[@599CD]

Sure. Make them as wide as you need.

[@amrasy]

thank you 4 the lesson but what if i wanna print it and the textbox have many lins

[@599CD]

You are very welcome. Glad you enjoyed!

[@eladborovsky3064]

thanks again for giving those amazing solutions to those annoying problems.
however, is there a way to use this solution in a Continus Form without expanding all the records?

[@599CD]

Nope. Single forms only.

[@enasnoraddin6755]

Thank you

[@599CD]

You're welcome

[@ibrahimsalad1432]

Thanks for your explain but how i made full screen for acces

[@599CD]

What do you mean?

[@kjohnson19615068]

How do you do that with a form, in access when you bring up a form you always have to resize, how do you automatically resize a form

[@599CD]

You can't easily automatically resize form fields in Access based on their content.

[@glenntaylor2863]

I tried this on one of my forms and it didn't work. I though it might have something to do with the "Can Grow" property and changed it to "Yes". Tried it again and still no luck. I wonder what's happening. It would be perfect for the text field I'm using but....

[@glenntaylor2863]

Instead of going directly to the fsubCustomers form, I had to go through the parent and click twice to get to the field in the fsub within the parent form...now it works. Wonder why the macro can't just be put on the subform itself and why you have to bring up the parent and access the sub form's field that way. Don't see the difference. Hmmm.

[@599CD]

Interesting. I'd honestly have to play with it myself to figure out what's going on.